Enter the name in Excel and the phone number will appear.

Create another query table.

B2=VLOOKUP(A2, Address Book! A: B, 2, 0)

A2 Enter the name and B2 display the corresponding number.

Of course, I'm answering your question. According to your question, you shouldn't ask questions in Excel. Suggestions: 1, find a fortune teller, 2, enter the national public security household registration system. Find one of the two methods.