View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default Vlookup selecting next highest value instead of equal or nearest l

Assuming that the lookup values are sorted ascending,
revise this Vlookup() formula:

=VLOOKUP(D1,A2:B15,2)

with this formula:

=VLOOKUP(SMALL(A2:A15,COUNTIF(A2:A15,"<"&$D$1)+1), A2:B15,2)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jack" wrote in message
...
Hi All .
Is there any way we can make Vlookup select the next value that is highest
or equal to in a cell instead of the nearest lower value
--
Jack