Need help with data sorting & updation

rthunukle 1 Posts Friday September 15, 2017Registration date September 15, 2017 Last seen - Sep 15, 2017 at 06:40 AM - Latest reply: ac3mark 9361 Posts Monday June 3, 2013Registration dateModeratorStatus May 25, 2018 Last seen
- 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.
See more 

Your reply

1 reply

ac3mark 9361 Posts Monday June 3, 2013Registration dateModeratorStatus May 25, 2018 Last seen - Sep 15, 2017 at 12:38 PM
0
Thank you
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?
Respond to ac3mark