IntermediateLookup & Reference
Look up a customer's region with XLOOKUP
Match a customer ID against a reference table to return their region.
XLOOKUP
8 min25 points
When can VLOOKUP not do the job?
The situation
A colleague insists VLOOKUP can handle any lookup and that XLOOKUP is a fashion. Before you argue, it is worth being precise about the one thing VLOOKUP actually cannot do, rather than the things it merely does awkwardly.
Functions in this exercise
- VLOOKUP — Finds a value in the first column of a table and returns a value from another column. Syntax and example
- XLOOKUP — Finds a value in one range and returns the matching value from another — in any direction. Syntax and example
Who this is for
Recommended next
Related exercises
- IntermediateLookup & Reference
Find a value with INDEX and MATCH
Combine INDEX and MATCH to look up a value without a fixed column number.
INDEX · MATCH
10 min25 points - IntermediateLookup & Reference
Look up a customer's region with XLOOKUP
Match a customer ID against a reference table to return their region.
XLOOKUP
8 min25 points - IntermediateLookup & Reference
Look up a unit price with VLOOKUP
Use VLOOKUP with exact match to pull prices from a product table.
VLOOKUP
8 min25 points