Excel, equating 2 columns formula

Hello,


I'm trying to take 3 columns and make them a bit neater.

Say column A came from a customer listing such things like Apple, Orange, Banana
Say column B is a set column to compare column A with, where if an item in column B equals column A then it should be equal to column C

So basicly, if A 1:? = B 1:? then the corresponding C to the column B should be displayed.

OK, perhaps I've even confused myself. If A1= Apple and in comparing the columns you find B12 = Apple then I want C12 which equals smoothie to be displayed.