Find Text Within Table, Return First Row Date, Then Compare to Today's Date

Hi -

I'm looking for a good way to search a personnel table for specific text in one column (wildcard method might be better, as I don't think all the instances are typed in exactly the same manner?).

On finding this text, I need the formula to return the value in column 1, which is a date, and compare this date to 'check the date in column 1 isn't MORE than X YEARS older than today's date'?

Today's date is a cell on the sheet.

I've attached a basic mock-up which hopefully explains what I'm after.

I can get the finding of the word formula working but not the date bit after that!

Thanks,

Stuart

Hi AliGW -

The formula can go anywhere really, though the shaded cell A11 is the original destination, though I obviously put text in that.

There are about 50 table for different people but this is one example. I'd be using the same formula on each tab to be honest

Thanks,

Stuart

Worked a treat, thank you so much

Thanks,

Stuart