John,

You are right. It worked.

Thanks again,

Coliber :)


John Michl Wrote:
Coliber, it doesn't need to be an exact match as long as you don't have
the FALSE parameter at the end of the formula. Assuming the dates are
in order, VLOOKUP will find the closest value without going over. Try
it. You'll see that it works.

- John


--
Coliber
------------------------------------------------------------------------
Coliber's Profile: http://www.excelforum.com/member.php...o&userid=30864
View this thread: http://www.excelforum.com/showthread...hreadid=505400