Compute commission VLOOKUP Excel 2010

Posted on 2011-10-30
Last Modified: 2012-05-12
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

Question by:perla1962

    Author Comment

    This is not a homework actually I don't go to school. You making a mistake I tried but I got an erro message.
    LVL 50

    Expert Comment

    Then why the stories about helping your father, helping your sister, doing it for your company???

    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.

    Author Comment

    Very well I will show you my steps and the error message and if you guys can help me will be really appreciate.
    LVL 92

    Accepted Solution


    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:


    Featured Post

    What Is Threat Intelligence?

    Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

    Join & Write a Comment

    INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now