🆚 Summary of Differences

Feature	VLOOKUP	HLOOKUP	XLOOKUP
Lookup direction	Down (vertical)	Across (horizontal)	Any direction
Lookup location must be	First column	First row	Anywhere
Can search left?	❌ No	❌ No	✔ Yes
Can return multiple columns?	❌	❌	✔
Required table format	Vertical only	Horizontal only	Any
Allows reverse search	❌	❌	✔
Built-in error handling	❌	❌	✔ [if_not_found]
Performance	Moderate	Moderate	Fast
Replaced by?	XLOOKUP	XLOOKUP	Modern standard

🎯 Use Cases

When to use VLOOKUP

• When working with older Excel versions (<2019).
• Simple vertical lookups.

When to use HLOOKUP

• Rare: only when data is arranged in row format (horizontal).

When to use XLOOKUP

• Always—if using Excel 365 or 2021.
• Large datasets, flexible lookups, error handling.
• When you need left lookup or return multiple results.

Using XLOOKUP (Modern Replacement for V & H Lookup)

Introduced in Excel 365 & Excel 2021.

✔ What it does

Searches any column or row, returns results from any direction, and supports default exact match.

✔ Orientation

Works both vertically and horizontally.

✔ Syntax

=XLOOKUP(lookup_value, lookup_array, return_array, [if_not_found], [match_mode], [search_mode])

✔ Advantages

• Can look left, right, up, or down.
• No column/row number needed.
• Handles errors with [if_not_found].
• Faster and more robust.
• Can return multiple columns at once.
• Supports approx, exact, wildcard, and reverse search.