Posted to microsoft.public.excel.misc
|
|
lookup? Index? match? formula
Yes, you're right! Thanks so much. It works perfect now!!!
"daddylonglegs" wrote:
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
|