Automatically fill in third column depending on data in second column

[J.J.]

I have a large list of data concerning events that happened in 2004.
Each event is either designated IR or Non-IR. I wish to create a macro
that would allow me to automatically find keywords and automatically
fill in the third column.

For example, if the second column's data has the word "Investor" in
the cell, the third column will automatically populate with the word
"IR"

The way I do it manually is to search the word "investor" and fill in
the data myself in the third column. It's terribly inefficient, and
any help would be great. Thanks!

 

[Gary''s Student]

In C1 enter:
=IF(B1="investor","IR","")
and copy down

 

[J.J.]

This doesn't meet my needs, sorry. Thanks though.