Return a value associated with a range of values, e.g. tax rates
 

Every 6 mos, the interest rate in my model changes. I want Excel to search a
column containing a list of 6-month ranges of dates, such as, 1/1/99 to
6/30/99; next, 7/1/99 to 12/31/99; next 1/1/00 to 6/30/00; next 12/31/00, and
so on for several years. Then return the interest rate specified next to the
date range within which a particular date specified in another cell falls.

Return a value associated with a range of values, e.g. tax rates
 

Sounds like a job for VLookup. Good help on this function is availabl
in the function wizard

Mat

--
Mallyca
-----------------------------------------------------------------------
Mallycat's Profile: http://www.excelforum.com/member.php...fo&userid=3551
View this thread: http://www.excelforum.com/showthread.php?threadid=55530