Excel: looking things up with XLOOKUP and VLOOKUP
Sign up free to unlock this topic
Kindergarten is free, and guests can try one sample topic in every other grade. A free parent or teacher account opens every topic from Kindergarten to Grade 12, college and university, and saves progress. No credit card.
Try the free sample: The ideal gas law · Have a class or homeroom code? Join here
Key idea: Excel: looking things up with XLOOKUP and VLOOKUP
XLOOKUP(what, where to look, what to return) finds a value in one column and returns the matching value from another. VLOOKUP(value, table, column number, FALSE) does the same when the key is in the table's first column.
Key words
- FALSE in VLOOKUP
- Exact match. Leave it out and results can be wrong.
- #N/A
- Nothing matched.
🔎 What to look for: Lookups can sit inside bigger formulas, like quantity × price.
