Looks through a row or column for a key and returns the value of the cell in a result range.
LOOKUP(search_key, search_range|search_result_array)
Simpler than VLOOKUP but requires sorted data. Use XLOOKUP instead when possible.
Need expert help? →