Use INDEX with MATCH instead of VLOOKUP in Spreadsheets

VLOOKUP returns janky values if the value you’re looking up doesn’t exist in the lookup column. Combine INDEX and MATCH for more reliable results.

For the long explanation, head over to Ablebits. If you’re Paul and just looking for a reminder of the format, here it is:
=INDEX (column to return a value from, MATCH (lookup valuecolumn to lookup against, 0))

Leave a Reply