If A3 is 240 and A4 is 0 then look up the rates from Sheet 2 A1:B7
using
the age in A1 or If A3 is 600 and A4 is 0 then look up the rates from
Sheet
2 C1:D7

=IF(AND(A3=240,A40),VLOOKUP(A1,Sheet2!A1:B7,2,FAL SE),IF(AND(A3=600,A40),VLOOKUP(A1,Sheet2!C1:D7,2, FALSE),0))


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=569604