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.