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.

Zero2Hero — Zéro2Héros