How to Lookup Table Using INDEX MATCH Formula in Excel 2016
FBTwitterReddit
video description
Rating: 4.0; Vote: 1
were going to show you how to lookup table using INDEX MATCH formula.
INDEXMATCH is a combination of the two formulas INDEX and MATCH.
INDEX works by looking through an array and grabbing the value of the given row/column.
MATCH works by searching for a value in an array, upon finding it, it will return the number of the corresponding row/column it found the value.
To combine these two formulas, it will look something like this in an example: =INDEX(E2: E8, MATCH(Jim, C2: C8, 0)
It will look for Jim, upon finding it, it will return the corresponding value in the E2: E8 array which would be 23
Craig: Does anyone know an easy way to match names that vary based on where the data comes from. I export several reports to excel and the names typically vary in how they are arranged. Example: John Smith OR Smith, John OR jsmith OR John Smith I am currently trying to create a sheet that has a Rep Name and i want to pull the data from the various sheets to match the Rep Name. Anyone one know of a way to bring in data to the Rep Name when the name varies in other sources. Date: 2023-07-08
