# Excel, equating 2 columns formula

Closed
squirrrelly1 - Jul 28, 2011 at 10:24 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jul 28, 2011 at 01:31 PM
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.
Related:

## 1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jul 28, 2011 at 01:31 PM
Sound like you are looking for VLOOKUP.
in your C column you can have

=VLOOKUP(A2, A:B, 2, false)