=IF(P2="Title","X","")

copy down



--


Regards,


Peo Sjoblom


"Nordic" wrote in message
...
How do I find certain text in one column and note it in another.
Example: Column P has Title and Regular in it. I want to note each time
Title is found and note it with an X in column B.

Column B Column P
X Title
Regular
Regular
X Title
Thanks for your help.
Nordic