Generate an Excel VLOOKUP formula.

How to use it

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

Use this page when you need a classic lookup formula and want a fast draft before adapting it to your workbook.

Step by step

• Describe the lookup key and the return value.
• Generate the formula.
• Replace the sample cell and range references with your actual sheet references.

Useful variations

• If you are on modern Excel, you can also ask for an XLOOKUP version.
• Mention exact-match behavior if that matters.

Worked example

Example input and output

Expected output