Report

Need help with data sorting & updation

Ask a question rthunukle 1Posts Friday September 15, 2017Registration date September 15, 2017 Last seen - Last answered on Sep 15, 2017 at 12:38 PM by ac3mark
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.
Helpful
+0
plus moins
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?
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!