How To Use Lookup And Reference Formula In MS Excel?

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.