Loading…
Loading…
Combine VLOOKUP with other ideas: multiply two lookups, let MATCH choose the column number so it follows the header name, and spot when a missing FALSE gives the wrong answer on unsorted data.
Syntax
VLOOKUP(value, table, MATCH(header, headers, 0), FALSE)
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.