I know there must be an easy way to do this and hope you guys can help.
I have posted a picture but here is what I want to do:
If the word on Column B is equal to Column F, I want the word in Column G to appear on Column C.
So, for example, C4 would be Apple, C5 would be Beef, and so on.
This is probably a very simple one but I am a beginner and would appreciate your help!
View best response
In C4 it could be
and drag it down
This formula in C4, copied down rows, will also return your desired result:
Thank you so much! @Twifoo
@Sergei Baklan Thank you very much!!
You're very much welcome!