jimmybangs
New Member
- Joined
- Nov 28, 2008
- Messages
- 36
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
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