Excel Formula Builder
Choose a formula type, fill in your cell references, and copy a ready-to-paste Excel formula.
XLOOKUP
Build a modern lookup formula that can search left, right, up, or down.
Cell or value to find.
One-column or one-row range to search.
Range with values to return.
Value to display when no match exists.
0 means exact match.
=XLOOKUP(A2, $D$2:$D$100, $E$2:$E$100, "Not found", 0)Checks Before You Paste
- •XLOOKUP is available in Microsoft 365 and Excel 2021+.
- •The lookup and return arrays must be the same length.
- •Use match mode 0 for exact matches.