Generate an Excel XLOOKUP formula.

How to use it

Start with the same request, then adjust it to your sheet.

XLOOKUP is the cleaner modern lookup pattern in Excel. Use this page when you want a more readable alternative to VLOOKUP.

Step by step

• Describe what you are matching on and what you want returned.
• Use the live generator to get the XLOOKUP syntax.
• Replace the sample references with your sheet ranges.

Useful variations

• Ask for a not-found value if blanks are not acceptable.
• Mention whether you need exact match or approximate logic.

Worked example

Example input and output

Expected output