How To Use VLOOKUP in MS Excel
Now we will see one of the special functionality of MS Excel i.e. VLOOKUP.
VLOOKUP means Vertical look up, and HLOOKUP means Horizontal look up.
Suppose we have a table which is vertical in nature, then we can select it
and use Transpose option by right clicking to convert it into horizontal
table where we will need to use HLOOKUP function, while if it was kept
vertical than VLOOKUP.
Using vlookup we can compare any two tables with each other.
This function compares the value of any one column from both tables to each
other and then give the required value in the particular cell.
Now to apply this function we will write it as a normal formula that is
'=vlookup(A1,L3:M3,2' where A1 is the value which we need to compare, L3:M3
is the table with which we need to compare A1, and we have written 2 at
last because that column's value we need to print from the table.
Now to apply this formula for whole column we can use our absolute value
function by pressing F4 key, and then drag it according to our requirement.
So this is how VLOOKUP function works, and whenever we use this function we
need to take care of one thing that is the table should be in ascending
order.
Share a personalized message with your friends.