Apple Numbers - Search table column and copy results from 1 sheet to another

Question

Level 1

4 points

Apple Numbers - Search table column and copy results from 1 sheet to another

Hello,

I have 2 sheets that I am looking to merge data into 1 column. Sorting and copy/paste wont work as on sheet 1 there is multiple rows for each customer on sheet 1. Sheet 1 has 42,000 rows and sheet 2 has 11,000 rows.

Sheet 1 contains multiple rows of data for each customer. I have the phone number and name on each row of this sheet.

Sheet 2 contains the unique Account ID, phone number email, etc.

I want to copy the account ID from sheet 2 to sheet 1.

I am looking for a solution to compare the phone number from sheet 1 to sheet 2, then search the Account ID field on sheet 2, to then return the result to sheet 1 to fill in the missing account id data on sheet 1.

iPad Pro, iPadOS 17

Posted on May 6, 2024 8:38 AM

Reply

Answer 1

SGIII

Level 8

35,378 points

May 6, 2024 5:11 PM in response to megadev_

Have you considered using XLOOKUP?

XLOOKUP - Apple Support

Have a look at the examples in the linked entry in Formulas and Functions Help.

Here's a simple example of what I am guessing you are trying to do.

In C2, filled down:

=XLOOKUP(A2,Table 2::Telephone,Table 2::Account ID,"not found")

SG

Reply

Answer 2

megadev_ Author

Level 1

4 points

May 7, 2024 6:20 AM in response to SGIII

I have tried this. The issue I am finding is that many of the entries come back as not found even when the 2 fields have the same phone number. When I use cmd f to find and copy the cell entry, it finds both.

any suggestions?

Reply