What is a Lookup Formula?
A lookup formula searches for a value in one column (or row) and returns a related value from another column (or row).
What is the syntax for Excel LOOKUP?
LOOKUP can be used in Excel in two ways: as a vector function or as an array function. Using it as a vector function is probably more popular though. The syntax shown here works in Excel versions from Office 2016 onwards as well as Microsoft 365.
=LOOKUP(lookup value, lookup vector, [result vector])
For Example:
| A (Employee ID) | B (Name) | C (Salary) |
|---|
| 101 | John | 50000 |
| 102 | Sara | 60000 |
| 103 | Mike | 55000 |
- Cell E2 =
102 - You want to find Sara’s Salary.