XLOOKUP Google Sheet Formula

Generate Google Sheet XLOOKUP Formulas in seconds

Try Formula Generator View Examples

Interactive Formula Generator

Formula Generator

Create complex Google Sheets formulas with natural language. Simply describe what you want to calculate.

Upgrade to Sheet Alchemy Pro

Get advanced formulas, batch processing, and priority support

Upgrade Now

Input

Result

Your formula will be displayed here:

Your formula will appear here

Describe what you want to calculate and click Generate

Pro Features Available

Sheet Alchemy Pro includes additional advanced features to enhance your formula generation.

Advanced Formulas

Complex array formulas and dynamic ranges

Batch Processing

Generate multiple formulas at once

Unlimited History

Save and organize all your formulas

XLOOKUP Formula Syntax

=XLOOKUP("Smith", A2:A20, C2:C20, "Not Found", 0, 1)

Example Use Case

Looking up values with enhanced flexibility and control

Understanding the XLOOKUP Formula

The XLOOKUP function in Excel is a modern, flexible replacement for VLOOKUP and HLOOKUP, searching for a match in a range and returning a corresponding value from another range. It's a powerful lookup tool without the limitations of older functions—like being able to look in any direction or return multiple values.

XLOOKUP("Smith", A2:A20, C2:C20, "Not Found", 0, 1) finds "Smith" in A2:A20 and returns the corresponding value from C2:C20, or "Not Found" if not matched. It takes lookup_value, lookup_array, return_array, and optional arguments for if_not_found, match_mode (0=exact, others for approximate), and search_mode (1=first-to-last, etc.).

Why Use XLOOKUP?

XLOOKUP offers superior flexibility—think complex lookups or multi-column returns. Its advanced feature set overcomes limitations of VLOOKUP/HLOOKUP, with the lookup array being anywhere, the ability to search in any direction, and support for multiple return values.

Example with Sample Data

Scenario	Formula	Result
Basic lookup with fallback	=XLOOKUP("Smith", A2:A20, C2:C20, "Not Found")	$50,000 (or "Not Found")
Return multiple columns	=XLOOKUP("ABC123", A2:A20, C2:E20)	[3 values as array]
Two-way lookup (intersection)	=XLOOKUP("Smith", A2:A20, XLOOKUP("2023", B1:F1, B2:F20))	[Smith's value for 2023]

XLOOKUP modernizes lookups: finds "Smith" in any column, returns from any other column, with fallbacks and search options. It's the ultimate lookup evolution.