Lookup & Reference

XLOOKUP

Searches a range or an array for a match and returns the corresponding item from a second range or array. The modern replacement for VLOOKUP/HLOOKUP.

Syntax

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

Usage Examples

See how this formula can be used in real-world scenarios, generated by AI.