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: