Excel Forum
Similar Content
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...
Error Values in Excel - Full Explanation
Tutorial: Here, I'll teach you what the errors in Excel mean.  There are many errors that you can ...
Best Lookup Formula in Excel - Index and Match
Tutorial: A lookup using INDEX and MATCH is like a VLOOKUP without the restrictions.  Index and Mat...



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.





Got a Question? Ask it Here in the Forum.