Course
XLOOKUP practice exercises
Ten exercises, from your first XLOOKUP to a two-way lookup with nested XLOOKUP. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 10
Find an order’s amount
In F2, write an XLOOKUP that returns the amount of order 5024, using the orders in A1:D9.
| Order no. | Customer | City | Amount ($) | Amount of order 5024 ($) | |
| 5031 | Bluebird Café | Boston | 412.50 | ||
| 5007 | Harbor Books | Denver | 86.00 | ||
| 5024 | Maple Dental | Austin | 1,290.00 | ||
| 5012 | Summit Gym | Seattle | 245.00 | ||
| 5040 | Pine Street Bakery | Chicago | 37.90 | ||
| 5019 | Copper Kettle Deli | Portland | 768.00 | ||
| 5003 | Riverside Garage | Miami | 159.00 | ||
| 5028 | Oak & Ivy Florist | Phoenix | 532.00 |