Need help with data sorting & updation

Closed
rthunukle Posts 1 Registration date Friday September 15, 2017 Status Member Last seen September 15, 2017 - Updated on Sep 15, 2017 at 06:42 AM
 Blocked Profile - Sep 15, 2017 at 12:38 PM
Hello,

I have a sheet with 6 coulmns each with (ABC & DEF) some value and different data
Column A & D have same values.
e.g. A B C D E F
I want to check one value from column A with D
If a match is found then it must update value in column B & C from E & F respectively.
For example:
A B C D E F
1 2 3 4 5 6
11 23 34 1 54 87

After applying formula, I should get:
A B C D E F
1 54 87 4 5 6
11 23 34 1 54 87

Please suggest, have a lot of data to update.

1 response

Blocked Profile
Sep 15, 2017 at 12:38 PM
Well, first of all, yo uwould need to press a button in o0rder for this to take place, as excel cannot update a value of another cell without user interaction. This is a rather complex deployment if you have never done this before. Have you written the =IF logic yet?
0