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

Question

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

ac3mark · Answer

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.

Compare 2 columns on different sheets and move data when match

1 response

Similar discussions

Subscribe To Our Newsletter!