Excel formula guide · Beginner
XLOOKUP: find a matching value in Excel
XLOOKUP finds a value in one range and returns the corresponding value from another. It is useful for product prices, names, or reference tables.
Practice this formulaSyntax
=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found])
A simple example
=XLOOKUP("Pen",A2:A4,B2:B4)
If Pen is in A3 and its price is 4 in B3, the result is 4. The lookup and return ranges must line up.
What to watch for
XLOOKUP defaults to an exact match. Add a fourth argument such as "Not found" for a missing item. XLOOKUP is available in Microsoft 365 and newer perpetual Excel releases; older versions may need another lookup approach.
Build confidence with practice
Try the guided exercise in Sheetstep, then change a number in the practice workbook and observe the result. Use the skills quiz to check what you remember.