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

# 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
• 2
1 Solution

Microsoft MVP ExcelCommented:
Perla,

it works pretty much the same way as in your other six questions about Vlookup.
0

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

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