Excel table, table 1 is the daily sales record, and table 2 is the household information. Now I want to add the customer's contact information after the daily record of table 1. What should I do?

Copy and paste the customer data in Table 2, link it to the auxiliary column of Table 1, and then make a data validity column with a drop-down arrow for selection.

If your customer information has the product number or name provided by the supplier, please use VLOOKUP (). When you enter a number, the result will be displayed automatically. It depends on whether the number or product name is entered in table 1, and whether the same field name and contact information exist in table 2.