Lookups-an exact match is not found

In HLOOKUP, If an exact match is not found, the next largest value that is
less than lookup_value is returned. I have a row of dates and I want the
next smallest value that is greater than lookup_value, which is NOW(). So if
today is 5/13/05 and the entries in the row are 3/1/05, 3/15/05, 4/16/05,
5/3/05, 5/20/05 and 5/22/05, I would want the value 5/20/05 returned, not the
value 5/3/05 as VLOOKUPO would do. Is there an easy way to do that? Thanks
in advance.

Hi!

Here's one way:

Entered with the key combo of CTRL,SHIFT,ENTER:

Assume your lookup value is in cell A1 and the lookup dates are in the range
C1:H1:

=IF(OR(MAX(C1:H1)<A1,A1=""),"",MIN(IF(C1:H1>A1,C1:H1)))

Format the cell as DATE

Biff

"Mike O'Donnell, Columbia MD" <Mike O'Donnell, Columbia
[email protected]> wrote in message
news:[email protected]...
> In HLOOKUP, If an exact match is not found, the next largest value that is
> less than lookup_value is returned. I have a row of dates and I want the
> next smallest value that is greater than lookup_value, which is NOW(). So
> if
> today is 5/13/05 and the entries in the row are 3/1/05, 3/15/05, 4/16/05,
> 5/3/05, 5/20/05 and 5/22/05, I would want the value 5/20/05 returned, not
> the
> value 5/3/05 as VLOOKUPO would do. Is there an easy way to do that?
> Thanks
> in advance.