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

Hi

You can make VLOOKUP select Exact value only setting 4th parameter to False.
With 4th paramaeter True (or omitted), your table must be sorted. I myself
never use VLOOKUP this way, but probably the sorting order (ascending vs.
descending) determines, is nearest higher or lower value returned, when
exact match doesn't exist.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"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