What is the LOOKUP Function?
The LOOKUPfunctionin Excel is used to look up information in a row or column.
There are two ways to write a LOOKUPformulain Excel depending on your needs.
One form is called vector and the other isarray.
The LOOKUP function can be used in every version of Excel.
Thatrangeis called the vector.
The value that’s returned is whatever is in the same position as the other selected data set.
Instead of choosing two single columns, we’re selecting the entire table.
You canread more about mixed cell references here.
Similar to the number example, this one simply identifies the last cell that contains text.
Other Functions Like LOOKUP
LOOKUP is a fairly basic lookup/reference function.
Others exist that are good for more advanced uses.
VLOOKUP andHLOOKUPlet you perform vertical or horizontal lookups and can specify whether to do an exact or approximate match.
LOOKUP automatically returns the closest value if an exact match isn’t found.
XLOOKUPis a similar, more advanced lookup function.
