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.
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………….!!!