Look up a value with XLOOKUP
Fetching a value from another column by matching a key — the single most-used skill in any real spreadsheet.
The data
| Row number | A | B | C |
|---|---|---|---|
| 1 | SKU | Product | Price |
| 2 | A-101 | Wireless Mouse | 24.5 |
| 3 | A-102 | USB-C Dock | 89 |
| 4 | B-204 | Monitor 27" | 310 |
| 5 | B-205 | Standing Desk | 445 |
| 6 | C-310 | Webcam HD | 62 |
Your task
Put a formula in F2 that returns the price for SKU B-204 by looking it up in column A.
Your formula goes in F2
The checker compares your formula against the accepted answers — it does not run it. The expected result is shown with the solution so you can verify it in your own spreadsheet.
Why this is the right formula
All three work, and which you reach for matters. XLOOKUP defaults to an exact match and references the return column directly, so inserting a column between A and C cannot break it. VLOOKUP hard-codes the column number 3, which silently returns the wrong column after an insertion — the most common way an inherited lookup goes wrong. INDEX with MATCH is the portable middle ground that works in every version.
Try next
Practise it on a full dataset
Free to use, share and republish — including commercially. Attribution isn't required, but it's what keeps these free to make, and there's one ready to paste below.
Questions
Does this actually run my formula?
The checker normalises case, spaces, argument separators and dollar-sign anchors, then compares your formula with a reviewed list of accepted answers. It does not evaluate the formula. Copy the data into your spreadsheet to verify the expected result independently.
Can a correct formula be rejected?
Yes. The accepted list includes several reviewed approaches, but cannot recognise every equivalent formula. Compare an unlisted solution with the expected result in your spreadsheet and use the page feedback if an accepted answer is missing.
Do I need an account?
No. There is no signup, no progress tracking and nothing stored — everything happens in your browser.