View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bhupinder Rayat Bhupinder Rayat is offline
external usenet poster
 
Posts: 64
Default Using MATCH / LOOKUP to find the next highest value.

Hi All,

How can I use MATCH to find the next highest value when there isn't exact
match.

E.g

1-Jan-08
3-Jan-08
4-Jan-08
5-Jan-08

If I match the array to 2-Jan-08, it returns the postion of 1-Jan-08, I want
it to return the 3-Jan-08 position.

The dates have to be in ascending order so changing to descending order and
returning match_type -1 is not an option.

Any ideas?

Thanks in advance.

Regards,

B/