Excel Automatically Insert Employee Number

Good morning,

I was wondering if it is possible with excel, to automatically insert an employees number if their name is inserted.

Example
Column A If Smith, John is entered in Column B automatically have his employee number show 5668?
Joe, Mary entered in Column A Column B to show 12345


This would save me a huge amount of time going back and fourth.

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

Yes I do. On I copied it into another sheet same workbook. Column A has all the employee names and Column B has their numbers. What would the Vlookup formula be? Also if I apply it to the entire column A. How can I leave it that the is nothing showing in that column until something is entered in column a?

Put this in B2 of Sheet1, assuming you enter the first employee's name in A2 and that your table of names and numbers is in Sheet2:

=IF(A2="","",VLOOKUP(A2,'Sheet2'!A:B,2,0))

then copy down as far as you need to.

Hope this helps.

Pete