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.