Search a column for up to 30 words then insert a different word in a separate column

Hello, first post. I am trying to create what I think is an IF formula. In column C, I want to search the entire column for a word and place another word in column D in the same row. Then I want to be able to search column D for a word and in the same row in insert a different word in column E. For example, if the word "school" is found in a row in column C, I need to place "Bus" in column D in the same row as "school" was in column C. Then if "Bus" is found in column D, I need "45" to appear in column E in the same row as "School" and "Bus".

Is this doable? Seems pretty straight forward but not sure how to accomplish this. I need to enter approx 30 words to search for in column C and D and input approx 30 different numbers in column E. Thank you so much!

Screenshot (1).png

Here is a screen shot

Originally Posted by ChemistB

Sounds like you will need to work with INDEX/MATCH or VLOOKUP Tables. An example sheet (Go Advanced>Manage Attachments) will help.

Can you elaborate? Not sure what you meant by " An example sheet (Go Advanced>Manage Attachments) will help"? Are these types of tables that I incorporate into my sheet?

Wow, thank you so much! Now in terms of copying the formula....it seems it's not as simple as a copy paste correct? Do i have to paste it line by line to increase the row value?

Thank you so much ChemistB, I was having problems pasting it because I continued my column further than my column C value. Much appreciated!