81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Returns the values in the result range based on the position where a match was found in the lookup range. If no match is found, it returns the closest match.

How To Use in Sheets

XLOOKUP(search_key, lookup_range, result_range, missing_value, [match_mode], [search_mode])

External Links

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.