That trick is Index/Match, a function that can find any value in any spreadsheet. One of the most common uses of Excel is as a database program, and oftentimes you've got to search the sheet for a ...

Write the formula: Use =INDEX(range, MATCH(lookup_value, lookup_range, match_type)) to combine both functions. Practice with examples: Apply the formula to real datasets to understand its ...

Once you have mastered VLOOKUP in Excel it's time to move on to INDEX/MATCH. This formula combination gives the same results but without the problems of VLOOKUP. Produced by Sara Silverstein.