The syntax ( the way how formula is phrased for excel) of VLOOKUP is
=VLOOKUP(cell address of value to be matched, range of cells to search, column number to return the value, match should be approximate or exact)
So, a sample format is here. Suppose the value to be found is in cell H13 and the table from which the value is to be extracted has the range I12:K25 (3 columns) and the match is to be exact.The format in the output cell will be
This will find out the value of H13 in the table I12:K25 and return the value of third column i.e. K if it could find H13 in the table’s first column.
THE FOURTH ARGUMENT WHICH IS DECLARED AS TRUE/FALSE OR 0/1 TELLS THE EXCEL TO PERFORM EXACT OR APPROXIMATE MATCH.
The table is given below. There are a few details given about the employees. (The table can be copied and pasted in Excel).
Kindly paste it at H6. NAME SHOULD COME AT H6, So that the solution matches with yours.
This is a simple problem having only one step and the usage of a single function VLOOKUP.
One main point to be noticed here is that there is no employee whose salary is exactly 80000. So
we’ll make use of APPROXIMATE MATCH.
APPROXIMATE MATCH:If enabled, will find out the available match or the next lesser value than the value to be found.
So let us apply the formula.
Let us find the salary first.
OTHER WAYS TO REACH THIS ARTICLE
YOU MAY LIKE