Replace =VLOOKUP(A3,E3:F27,2,FALSE) with =VLOOKUP(A3,E:F,2,FALSE) in B3 and
copy down [E:F uses the whole columns E & F]

What SMARTIN has written is also correct but I always use the E:F syntax as
it is cleaner and I can later add lookup pairs later without redoing the
formulae.

"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.