I'm new to excel and I've been looking around but haven't found anything yet. I need a formula that let me change the value in column B with the value from column D. But to do the change I have to check that the value in column C is equal to the value in column A. If a value from column A is not present in column C (like 1002 in the example), the value in column B wont change. The values in columns A and C are alphanumeric, the values in columns B and D are numeric.

For example:

Column A Column B Column C Column D

1001 2 1001 4

1002 1 1003 5

1003 0 1004 1

1004 2

The columns A and B should end like this (Changed):

1001 4

1002 1

1003 5

1004 1

Thanks for any help that you can give me.