Lookup & Reference

Excel formula for Look up a value with XLOOKUP

The modern, flexible lookup — searches any direction with a clean result.

Copy this formula

=XLOOKUP(A2, Products, Prices)

How the formula works

XLOOKUP takes the lookup value, the lookup array, and the return array. It defaults to exact match, can look left or right, and accepts an if-not-found argument so you avoid wrapping it in IFERROR.

Examples

=XLOOKUP(A2, Products, Prices, "Not found")→$19.90

Returns the price, or a message if missing.

Other ways to do this

VLOOKUP (older Excel)

=VLOOKUP(A2, A:C, 3, FALSE)

Use when XLOOKUP isn't available.

FAQ

Which Excel versions have XLOOKUP?

Excel 365 and Excel 2021. For 2019 and earlier, use VLOOKUP or INDEX/MATCH.

Related formulas

Look up a value from another sheet Look up the last matching value Look up with two criteria

Functions used

XLOOKUP VLOOKUP

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free