INDEX-MATCH
Lookup FormulasLearn the INDEX-MATCH formula combination in Excel. More flexible than VLOOKUP, it allows lookups in any direction with better performance.
Syntax
INDEX(array, MATCH(lookup_value, lookup_array, [match_type]))Parameters
arrayThe range from which to return a value
lookup_valueThe value to find in the lookup_array
lookup_arrayThe range to search for the lookup_value
match_type0=exact, 1=less than, -1=greater than (optional)
Examples
=INDEX(C:C, MATCH(A2, B:B, 0))Find A2 in column B, return corresponding value from column C
=INDEX(A:A, MATCH(MAX(B:B), B:B, 0))Return value from column A where column B has maximum value
Common Errors
#N/A - MATCH cannot find the value
#REF! - INDEX reference is invalid
Pro Tips
More flexible than VLOOKUP - can look left
Better performance on large datasets
Can be used for two-way lookups
Related Functions
Need Help with INDEX-MATCH?
Describe your specific use case and our AI will generate the perfect INDEX-MATCH formula for you.
Generate INDEX-MATCH Formula