Find array value within a string

This is great thank you. Is there a way to adjust it so that, instead of a rendering a true/false, the formula renders the matching value from the D1:D2 table of "keywords"?

Originally Posted by DonkeyOte

If we assume your strings are in Col A and your table of "keywords" is say D1:D2 then

B1: =ISNUMBER(LOOKUP(9.99E+307,SEARCH($D$1:$D$2,$A1)))
copied down

replace SEARCH with FIND if you require case sensitivity

Welcome to the Board. Please ask questions in your own thread rather than the thread of another member. Given first post etc... I have on this occasion moved your post for you to a new dedicated thread.

In answer to your question:

=LOOKUP(9.99E+307,SEARCH($D$1:$D$2,$A1),$D$1:$D2)

Note that if no keyword is found the above will return an #N/A error - if you wish to handle that you can either via IFERROR or outer LOOKUP - given use of XL2010 the former would be the more logical approach.

Thank you very much! Of course it worked just fine. No problem for starting my own thread for new questions.

Regards