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.
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.