I know. Two different people created each of these spreadsheets. I am hoping since the Payroll Name and 401k Deduction Amount is really the only info I will be looking at, I can get a formula for those two columns.

You were on the right path with Jerry Bently, the formula just didn't work once I copied and pasted it into my spreadsheet.

I want to be able to take Column B from the second worksheet and have it auto-fill into column E of the first worksheet depending on the Payroll Name.

Then, I want Column D to auto-fill either "81" or "opt-out" depending on what is in column E on the first worksheet.