🗂️XLOOKUP Function
Also known as XLOOKUP, Microsoft Excel XLOOKUP
An Excel formula that finds a code in one column. It gives back what sits on that same row.
Think of it like
It is like finding a name on a class list. Then you read the phone number on the same line.
Example
Lucy has 500 staff IDs in column A and email addresses in column D. She types an ID into F2, and =XLOOKUP(F2, A2:A501, D2:D501) shows that person's email.
Why it matters
Joining two lists by a shared code is one of the most common jobs in a spreadsheet. XLOOKUP does it in one short formula.
Definition
Example code
excel
A B C
1 Code Item Price
2 P-101 Pencil 0.80
3 P-102 Notebook 4.50
4 P-103 Ruler 1.20
=XLOOKUP("P-102", A2:A4, C2:C4, "Not found")
4.50Common mistake
Key takeaways
- 1Three inputs. What to find, where to look, what to return.
- 2Exact by default. No match shows #N/A or your own message.
- 3Either side. The answer column can sit left or right.