How to Use Vlookup for Sales Commission Calculation

by on May 2, 2017

Sales Commission

Most of the time sales commission % is based upon the sales value. The higher the sales value the higher the sales commission %. Here we will use vlookup to calculate the sales %. Assume we have the below data. we need the formula to do the calculation for us correctly in Column J.

sales-commission-calculation

sales-commission-calculation

The vlookup formula for this problem is =VLOOKUP(G3,$C$3:$D$7,2). Dollar signs are used to lock the table range and 2 is the column number from which we need the data.

Our final results are shown in the image below.

sales-commission-calculation

sales-commission-calculation

Please follow and like us:
0

Leave a Reply

Your email address will not be published. Required fields are marked *