it work great

Thanks for reply

Hardeep kanwar

"smartin" wrote:


Hardeep_kanwar wrote:

Hi! Sir

Can you help me in this regard.

Attached Link is having the data in which I use vlookup with some repeated
entries but I couldnt find the specific solution.

http://www.savefiles.net/d/gnbg36h8mpr.html

Thanks in Advance

Hi Hardeep,

I think your formula in B3 should be
=VLOOKUP(A3,$E$3:$F$27,2,FALSE)

Note the absolute referencing in the lookup range.