As long as the dates don't overlap you could use

=SUMPRODUCT(--(Sheet2!A2:A200=D8),--(Sheet2!B2:B200<=D8),C2:C200)

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Jim" wrote in message
news:cHH_e.314911$on1.250098@clgrps13...
I need to know if this can be done. On sheet 2 I have 3 columns (A,B,C);
date from, date to and interest rate. I need a formula that would allow me
on sheet 1 to input a date in one cell (D8) and have the corresponding
interest rate (as shown on sheet 2) appear in another (F8). I've been
messin with this for weeks and am at my wits end :)

Thanks, Jim