▦ Sheetova
FREE SPREADSHEET TOOLS

XLOOKUP Formula Generator — Excel Exact Match | Sheetova

Build an XLOOKUP formula for Excel using lookup and return ranges, with a customizable not-found message.

Choose a formula type and enter ranges.

Template-based formula builder, not an AI model. Check cell references and adapt the output to your workbook.

XLOOKUP Formula Generator

XLOOKUP searches a lookup array and returns the corresponding value from a separate return array. Unlike VLOOKUP, the return range can be to the left or right of the lookup range. The standard syntax is XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode]).

Formula examples and explanation

For example, =XLOOKUP(E2,A2:A100,B2:B100,"Not found") finds the value in E2 within column A and returns the corresponding value from column B. Both ranges should cover the same number of rows. XLOOKUP is supported by modern Excel versions, but not all older versions.

How to use this formula builder

  1. Select the desired formula type from the dropdown.
  2. Enter the appropriate Excel cell ranges and lookup value. Values such as E2 refer to cells, whereas literal text criteria require quotation marks.
  3. Select Build formula and inspect the resulting expression.
  4. Copy the formula and test it in a workbook with representative data.

Common mistakes

An incorrect range, mismatched data types, or a missing exact-match setting can change the result. Use absolute references such as $A$2:$A$100 when you need the same lookup range while copying formulas to other cells. In locales that use semicolons as formula separators, replace commas with semicolons where necessary. Formula support varies by spreadsheet application and version.

When to use other spreadsheet tools

If you need to inspect an exported data file first, try our CSV viewer. For CSV cleanup, use the CSV cleaner. To convert a table between formats, see CSV to Excel or Excel to CSV.

Frequently asked questions

How is XLOOKUP different from VLOOKUP?

XLOOKUP uses separate lookup and return ranges and can search in either direction. VLOOKUP requires the lookup value to be in the first column of its table range.

Is this a generative AI formula assistant?

No. This version uses deterministic formula templates. It does not understand unrestricted natural-language instructions.

Can I use the generated formula in Google Sheets?

Many of these functions are supported in Google Sheets, but syntax and behavior may differ. Verify the formula in your spreadsheet.