How to use the If and Vlookup functions together in Excel

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.

Click here to download a comparison guide cheat sheet that lists out the differences between Simple Start, Essentials, Plus and Advanced subscriptions.

Disclaimer - I offer affiliate links. This may result in commissions payable to myself to support my family.

[agroasesor]

Sir, I do appreciate the time you provided in order to give us that so, we must use our logical part to accomplish goals.
Thanks a lot

[KiaraRoxATT]

This was so helpful for my MIS assignment. Thank you so much Steve!

[laurenshuler]

This video was super helpful for my Accounting Excel project. Thanks for taking the time to share!

[laviniaxxo]

Brilliant, thanks so much for the video. I am studying bookkeeping and building an excel workbook to help my learning and process how things go together. I was faced with a dilemma and wanted to do a Vlookup combined with an IF function. I couldn't quite get it to work. 5:35 of your video helped me a lot as I was able to see the results of calculations. I never understood Vlookup and some of these functions and how to get them to work, but now I am going great with them and getting more sophisticated in my formulas. Who would have thought I would be combining an IF Function with Vlookup, and I had to do TWO Vlookups in the Value if true calculation. Amazing. You've helped a lot. Thanks

[stephaniesmith]

Thank you for your great explanation, it really helped me to understand this concept!!

[rhondakozuska]

Thank you thank you thank you!!! This was the perfect solution for my payroll spreadsheet !

[tinagirl]

this really helped me on my assignment today. Thank you

[Sonicman]

Very helpful and explanatory video! Thank you!!!

[katrina]

Thanks for the tutorial. I need to learn more excel

[befreetofly]

Thank you, it was easy to understand your explanation :)

[BR-qioe]

Thank you man, you’re a hero, i have a major exam tomorrow and I didn’t know how to do it.

[LookatBowen]

Very useful information. Thank you very much for the tutorial.

[ellabuilding]

Very useful for my work. Thanks for this 😊

[mohamed_Riham]

Thank You sir, it helped in my critical situation

[beteltree]

Thank you! I'm putting this to use right away!

[ladynegrita]

Thank you, I found your video very helpful. I'm doing a course of produce complex spreadsheets and the IF function scares me! Some of my fears have been allayed!

[Anikaspar]

My problem is that I never remember these when I need them. I watch, I'm like: oh ok, then I forget.

[shrisatimedicals]

i want to lookup for data of certain value say if value in certain cell is >15000 what to do

[luispontes]

Awesome video. Totally solved my problem.

[lakshmid]

Hi Steve it was my interview question where i didnt crack it thank you so much. Please help me out to get job in MIS.