Hi shabs,

Am Tue, 12 Jun 2012 15:23:06 +0000 schrieb shabareesh:

if i use the function = vlookup(A1,A:B,2,1) i am getting 16 rather i
need to get 5 as output...

you have to sort your table ascending


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2