Use INDEX(MATCH) instead of an Excel LOOKUP Function

ByRick

For some lookups, the INDEX and MATCH functions used together may be the solution.  Together, they are more robust and versatile than VLOOKUP, HLOOKUP, and LOOKUP. MATCH returns the position of the matched item in a one-dimensional list. It can do an exact or approximate match.  MATCH(lookup_value, lookup_array, 0) does an exact match. INDEX returns…

Look up winners based on their scores: A Toastmasters contest in Excel

ByRick

Do you need to pick out a name from a list based on some data? It might be the best-performing employee or department. Or the machine next in need of a service. Or the supplier whose concrete mix was the most consistent, or many others. This isn’t specifically an engineering application, but of general use:…