If column I shows just numbers, e.g. 7 (not "7 years")
In A3
=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