Lookup text in 1 column and note it in another
 

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

Lookup text in 1 column and note it in another
 

=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