Need to compare 3 cells and replace 1

[jewelr]

Hello, I need to compare the value in 3 cells and if they match replace one of the cells value. For example, compare A2 and C2. If they match replace A2 with D2 value. Column A is going to have allot more values then Column C and D if that matters. See attached sheet for example.
Thank You!

Compare.xlsx

[ChemistB]

Okay, you say compare 3 cells, so does that mean A2 is compared to B2 and C2 and if it matches either, then replace A2 with D2?

Secondly, you say there are more values in A than in C and D. So if, let's say A25 matches B25, what would you replace it with? Or are we not just looking at one row at a time?

Lastly, FYI, this will require a macro to do once we figure out exactly what you want to do.

[jewelr]

Okay, you say compare 3 cells, so does that mean A2 is compared to B2 and C2 and if it matches either, then replace A2 with D2?

Secondly, you say there are more values in A than in C and D. So if, let's say A25 matches B25, what would you replace it with? Or are we not just looking at one row at a time?

Lastly, FYI, this will require a macro to do once we figure out exactly what you want to do.

No you can ignore column B because that is going to be identical to C. I need to compare Column A and column C. If any cells value match then replace the cell in column A with the cell of column D making sure to keep the same posistion of the cell in column A.

Since there are more values in column A then in column C, if C40 matches A150 then D40 will replace A150. Make sense?

OK, i think that may explain it better.

[Richard Buttrey]

Hi,

Without a macro you could use a helper column to establish what column A should be and then copy the helper column and paste it as values back to column A

So for instance in E2 copied down

Please Login or Register  to view this content.

[FlameRetired]

No you can ignore column B because that is going to be identical to C. I need to compare Column A and column C. If any cells value match then replace the cell in column A with the cell of column D making sure to keep the same posistion of the cell in column A.

Since there are more values in column A then in column C, if C40 matches A150 then D40 will replace A150. Make sense?

OK, i think that may explain it better.

Drawing from the uploaded workbook:

To clarify further, if it is the other way around....C150 matches A40.....then D150 replaces A40?

In addition there is a triplication of an item with-in A; C has the same duplicated with-in C. Which do you want to replace in A and where do you want it put?

[jewelr]

Hi,

Without a macro you could use a helper column to establish what column A should be and then copy the helper column and paste it as values back to column A

So for instance in E2 copied down

Please Login or Register  to view this content.

Thank You Richard Buttrey! That worked perfectly.

[jewelr]

To clarify further, if it is the other way around....C150 matches A40 then D150 replaces A40?

It was just the one way around. Thanks for chiming in FlameRetired! This is an awesome source for excel help .