Conditional copy of cells with corresponding values [Solved/Closed]

- - Latest reply:  DR999 - Nov 5, 2015 at 08:58 AM
I have a list of variables in column A. I also have their values in column B. I then have column C, which has variables from the list in column A but they are randomly repeating. My task is to copy cells of values from column B into column D to fill in values for the variables in column C. As it should be obvious, the values in column D have to correspond to the variables in column C.

Example:

Column A
Bread
Milk
Cheese

Column B
1.00
1.20
2.00

Column C
Milk
Cheese
Cheese
Milk
Bread

So, column D has to have values of the variables in column C and these values have to correspond to the values in column B. Is it possible to automatically find if a cell in column D has the text of any variables in column A, and, if it does, the corresponding value in column B is copied in the cell in column D?

Thank you!
See more 

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
January 6, 2016
0
Thank you
have a look at VLOOKUP formula
Thanks a lot for the tip!