How to use Vlookup in Excel

Basically, VLOOKUP lets you search for specific information in your spreadsheet. For example,if you have a list of employee details, you could search for the details of specific employee.

1.To use vlookup first of all we have to create table (as shown in figure.)

2. Select tables and give table names such as Hulk.(as shown in figure)

3.Now we will write his name TO SEE the vlookup such as we want to see mobile number of Ram. Then we will type Ram and use vlookup formula for Ram.

=VLOOKUP(H19,HULK,6,0)

EXPLANATION

H19= IF YOU WANT TO SEE VLOOKUP OF RAM THEN CLICK ON RAM, H19 WILL BE SELECTED AUTOMATICALLY.BY THIS YOU CAN SEE  ANYONE VLOOKUP.NOW HERE I AM USING RAM. (YOU CAN TYPE ANY ONE NAME INSTEAD OF Ram)

HULK= HULK IS TABLE NAME (TABLE ARRAY)

6= WRITE THAT COLUMN  NUMBER  WHICH COLUMN NUMBER YOU WANT TO SEE.(FOR EX. COL 6)

0= FALSE VALUE(IT SHOW EXACT VALUE)

4.And press enter.It show the mobile number of Ram.

Then it show the Mobile no. of Ram

Now you have learnt the use of vlookup .