Linking a number so that it brings up a name

I am trying to figure out how to link a number so that when said number is entered it automatically brings up the name that is associated with that number.

I have a spread sheet that has employee numbers and would like for it to bring up the name associated with that number every time I enter it. IE "Jane Doe is employee 111111" every time I enter 111111 I want "Jane Doe" to automatically be inserted.

How can I make this happen? I have looked for information and haven't been able to find anything that work. Thank you!

Sounds like a job for vlookup

=VLOOKUP(E1,A:B,2,FALSE)

E1 is the cell you type in an employee number
Columns A has your list of employee numbers, column B has the Names associated with those employee numbers.