I have a list of various test and number values in about 14000 lines. there
are about 20 potetial text words that i would like to check each line and see
if they contain any of the 20, if so return that value. The example below
shows the words i want to test against and the list of values which need to
be tested. the top and left line denote the excel column and row

EX

LIST OF WORDS TO LOOKUP
A B
1 COM
2 PUT
3 CALL
4 DELETED


LIST TO TEST
VALUES TO BE TESTED RESULT OF FORMULA
A B
11 ABCDE FG HI CALL Q 123 CALL
12 ABCDECALLQ123 CALL
13 ABCDEFG PUTLMNOP PUT
14 ACOM BCDEFG123 COM