Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
Solved

# Compute commission VLOOKUP Excel 2010

Posted on 2011-10-30
Medium Priority
314 Views
Hi,
Any suggestions on how to compute the commission with the following information.

Name      Dept         Sales           Commission Amount
Mary         2          4,005.78
Sue         1             500.00
Paulo         1             500.01
Rena          2          1,000.00
Stanford      2             250.00

TOTAL               \$  6,255.79        \$                 -

Dept 1                 Dept 2
Sales >= 0 and <=300               2%                         3%
Sales >300 and <=500              3%                         5%
Sales >500 and <=1000               6%                         7%
Sales >1000                              7%                         8%

Table to Compute Commission

0
Question by:perla1962
• 2

Author Comment

ID: 37052510
This is not a homework actually I don't go to school. You making a mistake I tried but I got an erro message.
0

LVL 50

Expert Comment

ID: 37052521

Your questions are like a textbook progression from a simple Vlookup to more complex scenarios. Vlookup with False parameter, Vlookup with TRUE parameter, adding two Vlookups with False parameter, adding two Vlookups with True parameter, etc....

If it's not homework, then come out with the complete picture, instead of feeding one question after the other and adding more and more criteria.

Post your workbook with the whole layout. Then we can give you the final formula in one go.

But I'm still convinced it's homework. The scenarios, the progression of complexity, the whole thing has homework written all over it.

If you have tried to apply what you have learned, but get an error: What is the formula you have tried? What is the error?

Show some respect for the people who are trying to help you and put in some effort, too. Post a file with what you have done so far.
0

Author Comment

ID: 37052534
Very well I will show you my steps and the error message and if you guys can help me will be really appreciate.
0

LVL 93

Accepted Solution

Patrick Matthews earned 2000 total points
ID: 37053258
perla1962,

I see that you still haven't posted an example.

In any event, this article will provide you with a complete overview of VLOOKUP syntax, along with troubleshooting tips for solving the most common issues people tend to have with VLOOKUP:

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_2637-Six-Reasons-Why-Your-VLOOKUP-or-HLOOKUP-Formula-Does-Not-Work.html

Patrick
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaacâ€¦
###### Suggested Courses
Course of the Month13 days, 13 hours left to enroll