Register now or log in to join your professional community.
VLOOKUP (Vertical Lookup) function to search by first column of a range of cells (must to be Left to Right Direction), and then return a value from any cell on the same row of the range using the number of column you want to search in.
=VLOOKUP(LookupValue,TableArray,ColumnNumber)
LOOKUP function returns a value from a range of cells (one row or one column),
=LOOKUP(LookupValue,LookupRange,ResultRange)
Note: LookupRange & ResultRange must be the same number of cells.
The V in VLOOKUP stands for 'Vertical,' which implies that it will work only on columns, where LOOKUP can scan columns or rows. Note also that LOOKUP is restricted to a single column or row, not a range, as VLOOKUP can span.
VLOOKUP function to search the first column of a range of cells, and then return a value from any cell on the same row of the range
LOOKUP function returns a value from a range (one row or one column) or from an array.
