Isn't B16 a date?, do you mean if DATEDIF(B16,TODAY(),"Y") is bigger
than 30? Possibly

=IF(DATEDIF(B16,TODAY(),"Y")30,25,VLOOKUP(DATEDIF (B16,TODAY(),"Y"),I:J,2,0))


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515134