Loading…
Loading…
A mixed review of the lookup toolkit: VLOOKUP for lookups to the right, XLOOKUP when you need to look left, INDEX MATCH when you want a flexible lookup, and a debugging challenge. Pick the right tool for each question.
Common mistakes
Read the lesson, then try it yourself in a live spreadsheet.