Getting the next higer value with Vlookup - True
in [Programming]
|
From: Roger Govier on 3 Feb 2010 06:57 Mea culpe!!! I posted in haste without thinking it through. You are quite right Jacob - and your posting is the answer I should have posted. -- Regards Roger Govier "Jacob Skaria" <JacobSkaria(a)discussions.microsoft.com> wrote in message news:31FF2371-E2D2-445C-9EE3-4FA3E2656AC6(a)microsoft.com... > and what if an exact match? > -- > Jacob > > > "Roger Govier" wrote: > >> Hi >> >> One way >> =INDEX(B2:B4,MATCH(7,A2:A4,1)+1) >> >> -- >> Regards >> Roger Govier >> >> "getu32" <getu32(a)gmail.com> wrote in message >> news:a1d39786-a5ee-43d9-877b-0cc75c4737c1(a)o28g2000yqh.googlegroups.com... >> > In VLookup / Hlookup function the True parameter gives the closest >> > match with the search value but less than the search value.... >> > >> > i want to get the next greatest values of the Search Value.... how to >> > do it.... >> > >> > Example ..... >> > >> > A B C >> > 5 10 15 >> > 6 11 16 >> > 9 14 19 >> > >> > If i use =Vlookup(7,[Array],2,0)/ >> > =Vlookup(7,Array],2,True) .... >> > the answer is get is 11 >> > >> > BUT how to get it as 14!!!??? >> > >> > Please reply me at : getu32(a)gmail.com >> > >> > __________ Information from ESET Smart Security, version of virus >> > signature database 4830 (20100203) __________ >> > >> > The message was checked by ESET Smart Security. >> > >> > http://www.eset.com >> > >> > >> > >> >> __________ Information from ESET Smart Security, version of virus >> signature database 4830 (20100203) __________ >> >> The message was checked by ESET Smart Security. >> >> http://www.eset.com >> >> >> >> . >> > > __________ Information from ESET Smart Security, version of virus > signature database 4830 (20100203) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > __________ Information from ESET Smart Security, version of virus signature database 4830 (20100203) __________ The message was checked by ESET Smart Security. http://www.eset.com |