Searching for Keywords in Excel

[jimmybangs]

Hi Guys,

Do anybody know how you can do IF Functions to search for keywords within a cell?

e.g.

If in cell A1 there is "A journalist for the Daily Telegraph blogging around Sport and New Media" but I want to search for the keyword "Journalist" is that a formula I can use so that a "Y" (or any value i choose comes up) in B1?

Is there a way you can do multiple keywords too?

Cheers,

James

 

[VoG]

Try

=IF(ISNUMBER(SEARCH("journalist",A1)),"Y","N")

 

[sanrv1f]

for multiple keywords

try

=IF(OR(ISNUMBER(SEARCH({"Col","Cat","can"},A1))),"Y","N")

 

[jimmybangs]

Great stuff...i'll be sure to try this,

Jim