Search for a word in a sentence and return something from a list|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi all
i am stuck with this formula because it calculates heavily every time it's run, isnt there an easier process?.

What it currenltly does is check if a word is in f.i. cell AJ6711, compares it to the list of entires in AY and returns the value behind it. 67 words in total with the target it needs to give in the cell next to it...

=IFERROR(INDEX('Auto Approved Interco'!$AZ:$AZ, AGGREGATE(16, 6, ROW($3:$70)*SIGN(MATCH("*"&'Auto Approved Interco'!$AY:$AY&"*", AJ6711, 0)), 1)),"Not found")

Thnaks !  Ralph