Hi.
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.
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.