Use the LOOKUP function to find a value in a one-row or one-column range and return a corresponding value from another range
Use the syntax `=LOOKUP(lookup_value, lookup_vector, [result_vector])`
Enter the value you want to search for in `lookup_value`
Select the range to search in as `lookup_vector`
Select the range to return results from as `result_vector` if needed
Make sure `lookup_vector` is sorted in ascending order
Use `=LOOKUP(A2, D2:D10, E2:E10)` to find a match for the value in A2 and return the corresponding value from E2:E10
Use `=LOOKUP(A2, D2:D10)` to return a matching value from the same range when no result range is provided
Use LOOKUP when you need an approximate match rather than an exact match
Use LOOKUP with numeric data, text data, or dates
Use LOOKUP to retrieve the last value in a row or column by searching for a very large number or text value
Use `=LOOKUP(9.99999999999999E+307, A:A)` to return the last numeric value in column A
Use `=LOOKUP(“zzz”, A:A)` to return the last text value in column A
Use `=LOOKUP(TRUE, A:A)` when working with logical values
Avoid LOOKUP if the data is not sorted in ascending order
Use XLOOKUP or VLOOKUP if you need exact-match lookup behavior or more flexibility