Excel table Two tables match the phone number according to the ID number.

Excel tables can use vlookup formula to match the ID number and phone number of two tables. The specific operation method is as follows:

1. Enter values in the table, assuming that the matching needs to be based on the data as shown in the figure.

2. Open another table that needs to match the phone number, enter "=" in the cell, click fx above, and select "Search and Reference" in the pop-up dialog box.

3. Select the function "vlookup".

4. Enter the corresponding value in the pop-up function parameter dialog box, or directly enter the formula "=VLOOKUP(A2, Sheet 1! $A$ 1:$B$9，2，0).

5. Click OK and drop down the formula to get the required matching value.