Do you have a separate table listing the employee names and numbers? If so, then a simple VLOOKUP formula could do this for you - post some details of sheet names, columns used etc.

Hope this helps.

Pete