VLOOKUP EXAMPLE IN EXCEL

Vlookup is an existing function in excel used to merge the values of other sheets with respect to some matching values in the same sheet. Here the matching value is Department.

We are having sheet called Department Codes with the below values,

Department Department code
CSE

5

ECE

9

IT

8

MECH

3

EEE

7

And we are also having STUDENT DETAILS in the separate sheet.

Roll No Name Department

1

Naveen CSE

2

Hems MECH

3

Selva ECE

4

chudar MECH

5

Aravind IT

 

Now we are going to take the department codes from the department codes sheet.

Vlookup should be,

=VLOOKUP(C3,’DEPARTMENT CODES’!$A$2:$B$6,2,FALSE)

Not,

=VLOOKUP(C3,’DEPARTMENT CODES’!A$2:B$6,2,FALSE)

Select the !A$2 and press F4 to get !$A$2.

vlookup in excel

Now we are having all the fields in the single sheet.

Roll No Name Department Department code

1

Naveen CSE

5

2

Hems MECH

3

3

Selva ECE

9

4

chudar MECH

3

5

Aravind IT

8

 

 

 

Thanks for reading this post………….!!!

789 total views, 6 views today

Leave a Reply

Your email address will not be published. Required fields are marked *