Excel Core Book
Get our FREE guide on Excel when you subscribe to our free newsletter
Finds the value specified (called lookup value) in the first column of the range specified and gets the corresponding figure from specific column in the same row where lookup value is found
Syntax of Excel VLOOKUP formula:
=Starting from top of the range(look for this value in the first column, of this range, and get the figure in corresponding row of this column, by performing exact/approximate match)
lookup_value: this is the value you want to lookup (find)
table_array: consider it a list of items that are arranged in numerous columns and rows. This basically makes up the whole area which you want to include in your search for specific value.
col_index_num: once the lookup value is found, this number tells excel from which column the value should be fetched corresponding to value looked up.
[range_lookup]: This is an optional argument. It can either be TRUE or FALSE. This is mentioned to dictate Excel if one wants an exact match or an approximate match. If it is left out empty then by default it is TRUE i.e. approx match for the lookup value.
In layman terms all of this can be said as:
So basically VLOOKUP tells Excel to initiate search in vertical manner going from top to bottom looking for the value in the first column of the specified range. Once value is found jump or skip x number of columns to reach the intended column and fetch the corresponding value on the same row from the column reached. Whether the match to be made is exact or approx depends on the option i.e. if exact option is selected and no exact value found then formula will return an error.
Consider following data:
In order to find the number of units for A4 from the data above, we will use the following formula in cell B13:
=VLOOKUP(A13,A1:C11,2,FALSE) and it will return 88