[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • 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

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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