In this video, I will teach you how to determine whether an individual made their sales goal, and if that is true, then calculate the commission rate using the Vlookup function in Excel to determine their total sales commission.