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
MD@discussions.microsoft.com> wrote in message
news:3ED8FA02-5713-43AD-B298-6FF58DC25D9E@microsoft.com...
> 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.