A B D E F Fname: G H 1 Lname: 2 3 Rep Q2 *** Use VLOOOKUP, don't use nested IF - this problem is for the practice of VLOOKUP, not IF. Q2 Commission 4 Name Sales ($) ($) 5 Adam $ 1,200 6 Ben $ 299 7 Candy $ 300 8 Dan $ 1,000 9 Edward $ 299 10 Frank $ 300 11 Greg $ 400 12 Hank $ 1,995 Q3 Q3 Commission Sales ($) ($) $ 1,500 Commission Rates Threshold ($) Rate $ 499 $ 0.00% $ 400 $ 300 1.50% $ 1,999 $ 500 2.00% $ 500 $ 1,000 2.20% $ 499 $ 2,000 2.50% $ 499 $ 2,000 13 (Note: The logic is similar to that of determining grades - A-B-C-D-F) 14 15 16 Hint: Commission = Sales X ComRate, and ComRate is to be found thru VLOOKUP If a sales amount reaches the threshold on column F, the rep will be entitled to the corresponding rate in G 17 Critical Q: Is this lookup "Range" or "Non-range"? Solution would be right there once this question is answered correctly. 18 19 Last HW, it was Sales * IF; 20 now, it's Sales * VLOOOKUP 2222222 21 23 24 25