I am trying to create a formula that pulls info from one sheet to another. The first sheet has the following info:
Position ID (A), Status (B), Payroll Name (C), Deduction Code (D), 401k Deduction Amount (E)
The second sheet has the following info:
Match (A), 401k Deduction Amount (B), Match 2 (C), Contribution (D), Payroll Name (E), Status (F)

I need 401k Deduction Amount brought into the first worksheet from the second and match it with the Payroll Name.

I would also like to create an "IF" formula (I think) that would auto-fill to "81" if a #% is entered, and "opt-out" if "opt-out" is entered.

Please help!!!