Excel Issues macro may be needed
Posted
by
user124643
on Super User
See other posts from Super User
or by user124643
Published on 2012-03-25T01:37:45Z
Indexed on
2012/03/25
11:34 UTC
Read the original article
Hit count: 296
excel-2007
I trying to compare lists in excel. There are two lists, one list just has one column and the other has two columns, and what I am trying to do is when column A matches column C than take the value in column D and use that to replace column A.
For example:
Column A Column B Column C Column D
Blue Blue Shirt
Blue Red Pants
Red Green Shoes
Red
Green
Green
Purple
So the completed list should look like:
Column A Column B Column C Column D
Shirt Blue Shirt
Shirt Red Pants
Pants Green Shoes
Pants
Shoes
Shoes
Purple
© Super User or respective owner