Download the New LearnVern Android App and enter Lucky Draw to win Free Certificate
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.
Have a friend to whom you would want to share this course?