How do I compare values in two tables and copy data if there is a match?

I have data in Table A under the Column name Recipient Name. I have the same data Column in Table B. In Table B I have another Column called Tracking Number with data. I need the formula to compare the Recipient Name in Table A with the Recipient Name in Table B and if there is a match place the tracking number from Table B into the Tracking Number Column in Table A. Thanks

You do not need a formula. What you need is a data processing operation.
Specifically, the operation “lookup and copy” is what you need.

If you do not want to copy data, but you want to link the records in table A and B, then use the operation “Auto add link”.

Thanks. I will give it a try. I saw the data processing in the manual but wa snot sure if that would work.

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.