INDEX MATCH Complete Guide: Why It's More Powerful Than VLOOKUP

INDEX MATCH combines INDEX and MATCH to look up values in any column and return from any other column—including to the left.

Generate your formula with our INDEX MATCH Generator.