When "word" is in A1, put a number 5 in C1, etc. (Rows need to align)

[Jennifre]

I am hoping that this is possible + easy! I am Excel-challenged.

I have a bunch of data. Certain words appear in various columns. I'd like to be able to direct Excel to:


If "word" resides in A1, put a "5" in C1.
And so on, so Excel will continue down all rows, looking for "word" in Col A,
and if there, adding a 5 to the same row Col C.


Thank you SO much in advance!!

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel...-column-add-different-column.html#post5308365

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).