INDEX MATCH Generator
Build flexible INDEX and MATCH lookup formulas that can return values from either side of your lookup range.
INDEX MATCH
Create a flexible lookup formula that does not require lookup values in the first column.
Range containing the values to return.
Cell or value to find.
Range to search for the lookup value.
=INDEX($B$2:$B$100, MATCH(A2, $C$2:$C$100, 0))Checks Before You Paste
- •INDEX MATCH can return values from columns to the left of the lookup range.
- •Use ranges with the same number of rows.
- •The final 0 in MATCH requests an exact match.