vlookup formula in Excel | vlookup function in excel | vlookup formula in excel with examples | vlookup syntax
vlookup formula in Excel | vlookup function in excel | vlookup formula in excel with examples | vlookup syntax
Vlookup Formula in excel finds the data related to the input value.
General formula for Vlookup is Vlookup(Lookupvalue, Table Array, Col index, [range lookup])
Example :
To find the lookup value first save the reference table array in sheet. (shown in Picture 1).
Next go the cell where you want to look up the values .
Type the above formula in cell B1.
In the formula
A1 = cell where you want to lookup value
AA1:AB4 = Table which is used as reference
2 = in the table which value to find. Here you are finding the second value
0 = finding the exact value. (if want to find approximately type 1 true in place of zero)
Type the values in cell A1 and you will get the results in B1 which is shown in Picture 3.
Comments
Post a Comment