Excel Forum

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.