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 ...
5 Bite-Size Vlookup Tricks for Excel
Tutorial: 5 tricks for using Vlookup on data that might not always be 'friendly.' This includes: Re...
Multiply by True and False in Excel
Tutorial: You can multiply numbers by TRUE and FALSE in Excel. This effectively allows you to elimi...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.