=VLOOKUP(A1,Sheet1!A1:B14,2,FALSE)

Pasted next to John smith where you want the answer to appear and wher A1 to
B14 are the 2 columns that contain your list of names and numbers

"Ernesto" wrote:

I have John Smith and his associated number on 1 sheet. One the next sheet I
have a list of names and the next column over I want to automatically
populate with the number if John Smith appears.

Ex: John Smith 32311 Next Sheet: Angela Thomas
John Smith
32311