Compare 2 columns on different sheets and move data when match [Closed]

AnnetteeBrown 1 Posts Thursday April 20, 2017Registration date April 20, 2017 Last seen - Apr 20, 2017 at 02:24 PM - Latest reply: ac3mark 9199 Posts Monday June 3, 2013Registration dateModeratorStatus April 23, 2018 Last seen
- Apr 21, 2017 at 02:17 PM
Hello,

I need to match 2 columns of data from 2 different worksheets and when they match, I need to move data from another column from one worksheet to the other.

Sheet 1
A B C
Name Address 1 Address 2
John 123 Main St Suite 4
John 567 Name Rd Suite 8
Mike 894 First St
Mike 100 Main St Suite 2

Sheet 2
A B C
Name Address 1 need to move address 2 here from Sheet 1 when Name and
Address 1 match



There can be one name with multiple addresses, so Column A will have duplicate names so vLookup cannot be used.


Thank you
See more 

1 reply

ac3mark 9199 Posts Monday June 3, 2013Registration dateModeratorStatus April 23, 2018 Last seen - Apr 21, 2017 at 02:17 PM
0
Helpful
Try something like this:

=if(sheet1cell=sheet2cell,moveit(sheet2cell))


Here is how it works.

The IF statement is standard, if (logic test, logic test is true, logic test is false). In the above example, we have dropped the False value of the logic test, as it is not mandatory. If the logic test is true, then the subroutine of moveit is fired. You will notice that we pass a variable to moveit. The routine of moveit takes the sheet2cell value and posts it onto your sheet that you want it moved to.

Let us know if this will work.