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.