Can you guys please help me out I’m trying to create a VLOOKUP that will display the holiday bonus base upon the following.
Employees in the IT department get a $500 bonus,
Employees in HR get a $700 bonus,
Employees in FINANCE get a $800 bonus, and
Employees in ACCTG get a $300 bonus.
Employee ID Dept Holiday Bonus