lookup? Index? match? formula

[Guest]

I have this formula in cell B17 =DATEDIF(B16,TODAY(),"Y")&" years,
"&DATEDIF(B16,TODAY(),"YM")&" months "&DATEDIF(B16,TODAY(),"MD")&" days" This
gives me the total years of employment. I need to take that info and match it
with column "I" then whatever is in column "J" send that to "A3"
Crude Example: If B17 = whats in column "I5" then send whats in column "J5"
to "A3"
B17 shows the years, months and days but column "I" only shows whole numbers
like 1,2,3,4, etc...can they still match for example: B17 = 7 years, 2 months
5 days, I need that to match with 7 years in column "I"
Thanks in Advance!! Tough one for me!

 

[daddylonglegs]

If column I shows just numbers, e.g. 7 (not "7 years")

In A3

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

 

[Guest]

Works Great, can it be modified to show 25 in A3 if B16 is greater than 30.

 

[daddylonglegs]

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))

 

[Guest]

Yes, you're right! Thanks so much. It works perfect now!!!