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

VLOOKUP Formula for Excel 2010

Hi,
I need your help to complete the VLOOKUP formula I need to SUM the salary and the commission (Commission is computed by multiplying a commission rate times the sales.)

I tried to use the following information to set up the table.
Employees in department 200 receive a $10,000 salary and a 2% commission.
Employees in department 300 receive a $5,000 salary and a 4% commission.
Employees in department 100 receive a $15,000 salary and a 1% commission.
Employees in department 400 receive a $8,000 salary and a 5% commission
I guess I can add the functions.

Name      Dept          Sales           Check Amount
Mary        200          4,000.00       
Sue          400           500.00       
George      300          1,000.00       
Istar          100            2,000.00       

TOTAL              $  7,500.00        $                 -  
                  
Table to Compute Check:      
                  

0
perla1962
Asked:
perla1962
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Perla,

it works pretty much the same way as in your other six questions about Vlookup.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Do you want to learn how to do it or do you just want us to do your work for you?

Here is the formula

=VLOOKUP(B2,$G$2:$I$5,2,0)+(C2*VLOOKUP(B2,$G$2:$I$5,3,0))

This relies on a lookup table of dept, salary and commission starting in G2.

See attached.

cheers, teylyn
Book2.xlsx
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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