Excel VLOOKUP / XLOOKUP Formula Generator
Pick your lookup value and column, and get a ready-to-paste formula with error handling built in
Builds working Excel XLOOKUP and VLOOKUP formulas through a simple form — just fill in your cell references and lookup range, and it wraps the result in IFERROR for you.
도구를 불러오는 중…
🔒 Everything runs 100% in your browser. Your files and input are never uploaded to any server.
How to use
- Pick XLOOKUP or VLOOKUP mode.
- Enter the cell to search for and the reference range, then copy the generated formula.
FAQ
- Does XLOOKUP work in older versions of Excel?
- XLOOKUP only works in Excel 2021 and Microsoft 365 or later, so if you're on an older version, use the VLOOKUP formula instead.
- Why does it wrap the formula in IFERROR automatically?
- So that when no match is found, your sheet shows a clean custom message or blank cell instead of a messy #N/A error.
- Should I use VLOOKUP or XLOOKUP?
- Use XLOOKUP if you need to look left of your search column or match multiple conditions at once. Use VLOOKUP if compatibility with older Excel versions matters more.