XLOOKUP practice exercises
Searches one column and returns the matching value from another. Work through these on the table below, then check each answer.
Practise interactively Type formulas into a live sheet with instant feedback. Free.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Order | Region | Rep | Units | Price | Revenue |
| 2 | 2301 | North | Raj | 9 | 18 | 162 |
| 3 | 2302 | West | Omar | 1 | 60 | 60 |
| 4 | 2303 | West | Ines | 5 | 30 | 150 |
| 5 | 2304 | South | Omar | 8 | 9 | 72 |
| 6 | 2305 | South | Lena | 1 | 12 | 12 |
| 7 | 2306 | West | Lena | 1 | 30 | 30 |
| 8 | 2307 | East | Lena | 1 | 45 | 45 |
| 9 | 2308 | West | Raj | 7 | 18 | 126 |
Use XLOOKUP to find the Price for order 2304.
Show answer
=XLOOKUP(2304,A2:A9,E2:E9)→ 9Use XLOOKUP to find the Price for order 2303.
Show answer
=XLOOKUP(2303,A2:A9,E2:E9)→ 30Use XLOOKUP to find the Price for order 2308.
Show answer
=XLOOKUP(2308,A2:A9,E2:E9)→ 18Use XLOOKUP to find the Region for order 2306.
Show answer
=XLOOKUP(2306,A2:A9,B2:B9)→ WestUse XLOOKUP to find the Price for order 2301.
Show answer
=XLOOKUP(2301,A2:A9,E2:E9)→ 18Use XLOOKUP to find the Price for order 2305.
Show answer
=XLOOKUP(2305,A2:A9,E2:E9)→ 12
New to XLOOKUP? Read the XLOOKUP guide first: syntax, a worked example and common mistakes.