|Excel And SQL .com|
Home > Excel Functions
Excel VLOOKUP Function
Excel's VLOOKUP function searches for a value in the first column of a specified range and returns a value in the same row from another column within that range.
=TRANSPOSE(ValueToLookFor, RangeToLookInto, ColumnNumberToReturnValueFrom, bExactMatch)
ValueToLookFor is a value is the value you want to match for, this could be a literal string or a cell reference.
RangeToLookInto is the reference to the range we will be searching in, like A1:D40 etc
ColumnNumberToReturnValueFrom is the position of the column with in RangeToLookInto to get the value from. Note that this is not the column number in the entire sheet. This is the relative column number within the RangeToLookInto.
bExactMatch is true and false boolean value to indicate if you want to do an exact match or partial match is fine. True indicates you want to do an exact match.
This formula looks for apple in range B2 to B10 and returns the match value from range D2 to D10. Note that 3rd argument 3 indicates the column position to return to. D column is actually the 3rd column within the range B2:D10.
=VLOOKUP("apple", B2:D10, 3)
|© All Rights Reserved. ExcelAndSql.com|