Vlookup Formula Second value

[Sakthivel85]

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

[vlady]

you could use this array formula(ctrl+shift+enter) not just enter

Please Login or Register  to view this content.

-> change the bold number 2 to 1 for the first instance