I want to assign certain names to a number

[l3lue]

i want to have a list of employee's and a list of numbers next to them..and i want to be able to type in the number and i want it to insert their name

 

[tactps]

If you have the list of numbers in column A and the names in column B:

Type the employee number in cell C1

In cell D1, use the following formula:
=vlookup(c1,a:b,2,false)

You will get an "N/A" if the number does not exist in your list.
Also ensure that the data in column A and in cell c1 are formatted as numbers or text (consistently)