Excel XLOOKUP Practice Question: Using XLOOKUP, find the price of the SKU typed in E2 and put it in F2.
The question
Using XLOOKUP, find the price of the SKU typed in E2 and put it in F2.
The data
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | SKU | Item | Price | SKU | Price | |
| 2 | S-301 | Cable | 150 | S-304 | ? | |
| 3 | S-302 | Adapter | 420 | |||
| 4 | S-303 | Hub | 1250 | |||
| 5 | S-304 | Charger | 780 | |||
| 6 | S-305 | Case | 360 | |||
| 7 | S-306 | Stand | 990 |
The yellow cell is where your answer goes.
Show answer
Answer in F2: 780
How it works
Explanation: XLOOKUP finds a value in one range and returns the matching value from another range. It is exact match by default, so you do not need to type FALSE.
Syntax: =XLOOKUP(lookup_value, lookup_array, return_array)
E2 is S-304, which is the Charger row. The return array is the Price column, so the answer is 780.
Try it yourself in the live sheet
Type your formula in the highlighted cell and get instant feedback. Free, no Excel install needed.
Try this question in the live sheet →XLOOKUP syntax
The modern replacement for VLOOKUP — searches any column and returns from any other, no column counting needed. XLOOKUP is used to pull matching data from one part of a workbook into another. Full XLOOKUP guide.
More XLOOKUP practice questions
- Find the name of the employee whose ID is typed in E2 and put it in F2.
- Using XLOOKUP, find the roll number of the student named in E2 and put it in F2. The…
- The code in D2 is not in the list. Make the formula show Not listed instead of an error…
- Using XLOOKUP, find the latest (last) amount paid by the customer typed in D2 and put it…
- Using XLOOKUP with an approximate match, find the commission rate for each rep from the…
- What share of total sales does the region typed in D2 have? Give it as a decimal and put…
- Using XLOOKUP, find the total cost of the quantity in F2 of the product typed in E2 and…
- Find the name of the student with the highest score and put it in D2.
All practice questions · Excel exercises · Interview prep · Cheat sheet