Excel Forum
Similar Content
Vlookup to Return All Matching Results
Tutorial: Here is an Excel formula that will act like a Vlookup that returns every matching result ...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...
Partial Match Lookup with Numbers in Excel
Tutorial: Perform lookups on numbers with partial matches. For instance, find the first number that...

Excel Magic Trick #206: Artists Commissions & VLOOKUP

See how to calculate Commissions with the VLOOKUP function when the Lookup value is an Account Type instead of a number. See an IF function formula that is less efficient than an alternative formula using the VLOOKUP function.
Also see these videos:
You Tubers Love Excel#5: IF formula too long use: VLOOKUP
Excel Lookup Series #3: VLOOKUP Function 3rd Example

Got a Question? Ask it Here in the Forum.