Excel Magic Trick 453: VLOOKUP for Commission Brackets Calculation (LOOKUP function also)

See how to calculate commission on sales when there is more than one level of commission incentive pay. See how to make the lookup table smartly to reduce formula size. See how to use 3 VLOOKUP functions in one formula, including looking up values in the 1st, 2nd and 3rd columns. See how to do the same formula with LOOKUP function to reduce formula size and formula creation time.

Excel Magic Trick 452

Commission Bracket tables are similar to Tax Bracket Tables.