In Excel, the INDEX function returns an item from a specific position (in a list, table, database). The MATCH function returns the position of a value (in a list, table, database). And ...

There's one trick, though, that separates the quants from the interns. 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 ...