Lookup and replace

[Deleted]

Hi there,

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!

Thanks

[#2]

@Deleted 

In C4 it could be

=IFERROR(INDEX($G:$G,MATCH($B4,$F:$F,0)),"no such")

and drag it down

[#3 · Accepted solution]

@Deleted 

This formula in C4, copied down rows, will also return your desired result: 

=IFNA(VLOOKUP(B4,F:G,2,0),

"Not Found")

[#4]

Thank you so much! @Twifoo 

[#5]

@Sergei Baklan Thank you very much!!

[#6]

@Deleted 

You're very much welcome!