Hi All,

I am not getting the Second value while using the VLookup function. I have used the formula " =VLOOKUP(G4,$B$3:$C$10,2,0) ". Can u please suggest me the correct Vlookup formula . Is there any formulas other the Vlookup to get the results what i want.

Letters Number
A 1
B 2
C 3
D 4
B 5
D 6
G 7

Results I Want Results I got using Vlookup
Letter Last Number Last Number
B 5 2
D 6 4


Thanks ,

Sakthivel