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

Hi Jack,

another alternative formula (longer but faster)

=IF(VLOOKUP(D1,A1:A20,1)=D1,INDEX($A$1:$B$20,MATCH (D1,A1:A20),2),INDEX($A$1:$B$20,MATCH(D1,A1:A20)+1 ,2))

Charles
__________________________________________________
The Excel Calculation Site
http://www.decisionmodels.com

"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