Searching for Keywords in Excel

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
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,651
Try

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

sanrv1f

MrExcel MVP
Joined
Jan 1, 2009
Messages
3,468
for multiple keywords

try

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

Forum statistics

Threads
1,084,884
Messages
5,380,436
Members
401,678
Latest member
saffar

Some videos you may like

This Week's Hot Topics

Top