I have been trying to find a formula, or combination of formulas that will copy a value from sheet 2 when I enter a name in sheet 1.

This is for a timesheet that requires ID numbers. Sheet 1 is the timesheet that goes to payroll where column A is the name of the employee for a specific shift and column B is their ID number. Sheet 2 is a table that has all employee names in column A and their ID numbers in column B.

I would like to be able to enter an employee's name in column A of sheet 1 and a formula would look through column A of sheet 2 for a match, and then return their ID number from column B of sheet 2 into column B of sheet 1.