Conditional copy of cells with corresponding values

Solved/Closed
DR999 - Nov 3, 2015 at 04:23 PM
 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!

1 reply

rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 768
Nov 3, 2015 at 07:33 PM
have a look at VLOOKUP formula
0
Thanks a lot for the tip!
0