LOOKUP

Definition: LOOKUP is a function that searches for a value in a range of cells and returns a corresponding value from the same position in another range of cells.

Syntax: =LOOKUP(lookup_value, lookup_vector, [result_vector])

Situation: This formula is appropriate when you need to search for a value in a range of cells and return a corresponding value from another range of cells.

Example: If you have a list of names and their corresponding phone numbers, and want to find the phone number for a specific name, the formula =LOOKUP(“Alice”, A1:A10, B1:B10) can be used, which returns the phone number for Alice.