In this video, I will teach you how to determine whether an individual made their sales goal, and if that is true, then lookup their commission rate using the Vlookup function to determine their sales commission total. If you'd like to support Scouting, my troop is raising money through online popcorn sales. Here is the store - https://www.prpopcornstore.com/?sid=TRB5DV. Get an Income & Expense Tracker Excel Template here: https://www.etsy.com/listing/1089584922/income-and-expense-tracker-excel Get 30% off QuickBooks Online with this link - https://quickbooks.intuit.com/partners/irp/qbo/?cid=irp-33189#pricing Get Rewind Backups for QuickBooks Online - https://rewindio.grsm.io/hn7nw5voyc5p Need a new Payroll provider? Go with Gusto - https://gusto.com/?referral_token=steve11327&utm_source=inapp Looking for a new bank account? Try Relay - https://app.relayfi.com/register?referralcode=sequentiasolutions Click here to download a comparison guide cheat sheet that lists out the differences between Simple Start, Essentials, Plus and Advanced subscriptions. https://1drv.ms/x/s!AmOflzuTYrYwmvc67bl_VV9QOvAukw?e=OBr1lS Got questions? Email Steve at stevechase@sequentiasolutions.com Disclaimer - I offer affiliate links. This may result in commissions payable to myself to support my family.

ExcelVlookupIf functions