• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 328
  • Last Modified:

VLOOKUP Excel 2010

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

92-5601           HR      
77-3407           IT      
66-1000           ACCTG      
77-3410           FINANCE      
95-6688           IT      
99-8989           HR      
0
perla1962
Asked:
perla1962
2 Solutions
 
Saqib Husain, SyedEngineerCommented:
Try

=VLOOKUP(B2,{"HR",700;"IT",500;"FINANCE",800;"ACCTG",300},2,0)
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

for ease of maintenance I suggest creating a lookup table somewhere in the spreadsheet and reference that.

See attached.

cheers, teylyn
Book1.xlsx
0
 
perla1962Author Commented:
Thank you very much.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Healthcare IT Tech

This course will help prep you to earn the CompTIA Healthcare IT Technician certification showing that you have the knowledge and skills needed to succeed in installing, managing, and troubleshooting IT systems in medical and clinical settings.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now