If cell contains a specific text then returns a text to specific cell

[hbtpoprock]

I want to search for a specific text within a specific roll, and if it's found, then it would return a specific text to a specific cell.

To say, I want to return the word "Good job" to B1 if there is the word "Office" in A1 repeatedly all the way down to the 4th row, and the formula must be contained in C1 or D1

Because I want to return something else for the word "Home" reasonably

	A	B	C	D
1	Office	Good job
2	Office	Good job
3	Home
4	Office	Good job

Thanks :)

[FDibbins]

Hi, welcome to the forum

If you only have a few options to choose from (say, 4 at most), you could use something like this...
=if(A1="Office","good job",if(A1="Home","blah", if(A1="cat","Dog"."")))

If, on the other hand, you have many options, it would probably be better to use VLOOKUP

[hbtpoprock]

Thank you for the reply! Your ans is very helpful. But I'm a newbie here, and I have a very specific condition that the formula must be contained in the column C or D. Do you kindly have another advice please?

[FDibbins]

So put my suggested formula in either C or D?