vlookup help required

[jb]

I have an excel file which contains roll number, name, grade of semester-III, grade of semester-IV and average of 49 students in column A to E.

Column G and H contains list of 57 students out of which 49 students are same.
But roll numbers are different.

Now in new 57 students list, I want to display grades of semester-IV in column I which is to be searched from list of 49 students. If a student is not present in 49 students list then it should display dash.

I have tried to use vlookup but it is giving error.

Help required.

File is uploaded for reference.

 

[deciog]

Using this way

=VLOOKUP(H2,$B$2:$E$50,4,FALSO)

Decio

 

[bosco_yip]

Maybe,

In I2, copy down :

=IFERROR(VLOOKUP(H2,B$2:E$50,3,FALSE),"---")

Regards

 

[Naresh Yadav]

Dear JB,

Pls type the below formula in your I column...

=IFERROR(VLOOKUP(H2,$B$2:$D$50,3,0),"-")

Regards
Naresh

 

[Sreeja]

Attached.

 

[jb]

Thank you all for your help. Thanks a lot.