Vlookup formula: =VLOOKUP(the sales figure in table 1, the sales figure along wi

Question

Vlookup formula:

=VLOOKUP(the sales figure in table 1, the sales figure along with commission rates in table 2, the column no which indicates the commission rates in table 2, approx value)

=VLOOKUP($B$2:$B$11,$G$2:$H$8,2,TRUE)

Name Sales comm % Commission Sales Comm % Applebee $171,900 6%VLOOKUP($B$2:$B$11,$G$2:$H$8,2,TRUE) 10314 $50,000 3% Bueller $93,500 9% 8415 $75,000 4% Chung $151,200 6% 9072 $100,000 5% Crawford $119,850 5% 5992.5 $125,000 6% Joyce $89,450 9% $175,000 8% KIng $124,500 5% 6225 $200,000 9% MacDonald $131,100 6% 7866 Richards $55,300 9% 4977 Tanaka $201,500 9% 18135

Explanation / Answer

VLOOKUP to calculate commission with approximate match

Name Sales comm % Commission Sales Comm % Calculate the Commission Percentage and the atual commission. Applebee $171,900 $50,000 3% Bueller $93,500 $75,000 4% Chung $151,200 $100,000 5% Crawford $119,850 $125,000 6% Joyce $89,450 $175,000 8% KIng $124,500 $200,000 9% MacDonald $131,100 Richards $55,300 Tanaka $201,500

Related Questions

Navigate

• Browse (All)
• Browse V
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.