VLOOKUP and IFNA for Commissions

Topics: Lookup Formulas, a few Statistics functions, Goal Seek

Topics in this video:

VLOOKUP and IFNA for Commissions:
VLOOKUP to look up an actual sales rep that has a contractual rate and then the IFNA to assign the flat commission rate when there is no contractual rate.