XLOOKUP()

Description

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

Google Docs Help

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.