Loading…
Loading…
INDEX and MATCH together make a flexible lookup: MATCH finds the row, INDEX returns the value from any column, including columns to the left of the lookup column. It keeps working when columns are inserted.
Syntax
INDEX(return_range, MATCH(lookup_value, lookup_range, 0))
Example: =INDEX(C2:C6,MATCH("Monitor",B2:B6,0)) returns the price of Monitor.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.