I used Vlookup in excel to pull column D information. Unsure on how to pull Commission (column E) and the sales commission in the bottom.

D6 X V fx =VLOOKUP(C6,$G$6:$H$12,2, TRUE) A B C D E F G H J K L M Employee Commission VLOOKUP to calculate commission with approximate match within a range Name Sales Comm % Commission Sales Comm % Applebee 171,900 6% S 09% --> for sales less than $50K, commission would be 0% Bueller 93,500 4% S 50,000 39% --> for sales $50K or above but less than $75K, commission would be 3% Chung 151,200 6% S 75,000 4% Crawford 119,850 5% $ 100,000 5% Joyce 89,450 4% $ 125,000 6% King 124,500 5% $ 175,000 8% MacDonald 131,100 6% $ 200,000 9% Richards 55,300 3% Tanaka 201,500 9% 6 Calculate the sales commission directly here in one formula using Vloopup: Commission CALCULATED .8 w/ Vlookup 23 Un