enter text based on search of multiple cells

[akamexcel]

Hi all
I'm trying to enter a value in a new cell based on a search for multiple terms in multiple cells. It seems to be working ok when I search one cell, but I haven't found a way to add a second cell to the search. Here's my current formula...
=IF(COUNT(SEARCH({"french","language","spanish","apac","chin","german","jp","jap"},P4)),"Yes","No")
On this one particular cell I'm working on, there is a match and "Yes" is correctly inserted in my new cell. But when I attempt to add a new cell to the search, "No" is entered, even though there is a match on the first cell. Have attempted many variations including below:
=IF(COUNT(SEARCH({"french","language","spanish","apac","chin","german","jp","jap"},P4:Q4))"Yes","No")

I'm sure there is a way to get this done. Thanks in advance for any responses

[sktneer]

Try this to see if this works for you.....

Please Login or Register  to view this content.

[akamexcel]

Worked like a charm. Thank you so much. Happy new year

[sktneer]

You're welcome.
If that takes care of your question, please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

Happy new year to you too.