Return employee name when the employee's number is entered

In my workbook I have a sheet that contains two columns. One has employee
name and the second has an employee number. Now, on another sheet I want to
enter an employee number and in the next cell have it return the employee's
name. How can I do this?