One mo

=if(countif(a1,"*" & "Base" & "*")=0,"","X")
or
=if(countif(a1,"*Base*")=0,"","X")
or
=if(countif(a1,"*" & C999 & "*")=0,"","X")
if c999 holds the word Base.

jerredjohnson wrote:

I have a column that has words in each cell. I want to search through
the column and for any cell containing the word 'base' i want to place
an X in the cell next to it.

How can I do this?

Please help!

Thanks,
Jerred

--
jerredjohnson
------------------------------------------------------------------------
jerredjohnson's Profile: http://www.excelforum.com/member.php...o&userid=32236
View this thread: http://www.excelforum.com/showthread...hreadid=550489

--

Dave Peterson