How to use the If and Vlookup functions together in Excel
HTML-код
- Опубликовано: 21 авг 2024
- 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 - www.prpopcorns....
Get an Income & Expense Tracker Excel Template here: www.etsy.com/l...
Get 30% off QuickBooks Online with this link - quickbooks.int...
Get Rewind Backups for QuickBooks Online - rewindio.grsm....
Need a new Payroll provider? Go with Gusto - gusto.com/?ref...
Looking for a new bank account? Try Relay - app.relayfi.co...
Click here to download a comparison guide cheat sheet that lists out the differences between Simple Start, Essentials, Plus and Advanced subscriptions.
1drv.ms/x/s!Am...
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.
Sir, I do appreciate the time you provided in order to give us that scenario..... so, we must use our logical part to accomplish goals.
Thanks a lot !!!!!!!!
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
bookkeeping is an honorable skill that can serve business owners well.
Thank you man , you’re a hero, i have a major exam tomorrow and I didn’t know how to do it.
you are welcome
I see a lot of ppl not giving you your roses, if you watch it and it works; the least you could do is "like" the video. 🤦🏿♂️👍
This was so helpful for my MIS assignment. Thank you so much Steve!
Thank You sir, it helped in my critical situation
This video was super helpful for my Accounting Excel project. Thanks for taking the time to share!
Thankyou Sir🙏❤👼👼
My problem is that I never remember these when I need them. I watch, I'm like: oh ok, then I forget.
Lol
Svg2we5vafcrcsa1qfcdgycy11ubuv Ucrânia
Thank you! I'm putting this to use right away!
Cool
this really helped me on my assignment today. Thank you
Very helpful and explanatory video! Thank you!!!
Thank you thank you thank you!!! This was the perfect solution for my payroll spreadsheet !
You are welcome Rhonda! I love it when payroll all matches up.
What can you do if you have a lookup value that is not found in the table array but you want a specific value or text in those corresponding cells? For example, you typed “F” as a value that was not found in the table array, what if you wanted all cells next to an F to say something?
Bless this video
Excellent Video Steve!!
Thank you!
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!
Glad to help. Look for excelisfun youtube channel for more videos.
Thanks Steve. its works perfectly
Nice work steve
Thanks 👍
Very useful for my work. Thanks for this 😊
happy to help
In my case, I would need an average of the E column based on the vlookup percentages. Is it possible? HELP PLEASE!
Yo I am trying to link several if statements and complimenting it with vlookup when true, exact match. Yet, somebody is not working . Can you show me how to do it?
Very helpful video
Glad I could help out. I did this before the Xlookup formula which you should take a look at xlookup formulas. More flexible than vlookup.
Very useful information. Thank you very much for the tutorial.
glad to it helped Mike
Thanks for the tutorial. I need to learn more excel
Smooth guy......really smooth.
How do u do total sales when adding sales and commission.
Great explanation. Thanks!
well done
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.
i want to lookup for data of certain value say if value in certain cell is >15000 what to do
Thank you for your great explanation, it really helped me to understand this concept!!
Stephanie Smith thanks
Thank you, it was easy to understand your explanation :)
Nice & clear explanation.
Awesome video. Totally solved my problem.
thank you
Thanks! Really helpful!
Thanks Steve
a side note I want to share is that, you can do iferror(vlookup(xxxxx), " ") to remove the NA error message.
I just discovered the iferror formula... it is awesome
Hi Steve. Can you walk me through the steps on how to use the (if function) to get a range of random numbers in a row in one column. eg: #1 - #36............ 2. 6. 9.17. 28. 35
Select the range of cells then type =randbetween(1,36) and press control + enter. It's important to copy and paste the results to values if you don't want them to update everytime you refresh the workbook.
Hi Steve. it is with great pleasure telling you thanks. I never know it could be that easy using =randbetween formulae. :-)
thanks steve, exactly what i was looking for. i have a question. if there are more then 2 columns to look up, for example 4. i did set up the table as you mentioned. the headers also need to be matched. if i email you sample of what i mean would that be ok.
stevechase@sequentiasolutions.com
I have a scenario in which i have to search products in 4 sheets in a workbook, i can use 2 vlookups in same formula but it wont let me place the 3rd formula. what do i do alongwith when the product is not found it gives error message "Product not found" same like your video giving No Comm. pls help
. Have you tried consolidating to 1 worksheet prior to the lookups?
Great help!
thank you so much
Hi Steve, Please help! I want to =VLOOKUP(A4,Greetings!A3:C19,3,0) BUT only if cell b4 has a alphanumeric value in it. Any ideas? So I want to vlook up a4 on another work sheet but only if cell b4 has text. Any clues, i've been searching for hours!
the iferror function can run through multiple vlookups if it doesn't find the value in one worksheet, it can do another vlookup in another worksheet.
what if you have repeating numbers i your sales or goals column. Will you be able to sill use the if or vlookup conditions. I'm asking because i have a similar situation as this video however, i have some repeating numbers, and sometimes when i use the look up function that I'm trying to get picked up, another number in my table picks up another number with similar number in one column but a different number in the other column
It will not work for repeating values. The Vlookup only works when it finds the first value.
Ok thanks for the help and again great video. Keep it up.
Hi Steve would you be willing to assist me with a spreadsheet Im trying to put together. Having a hard time trying to figure out which function would do what Im trying to.
Sorry I missed this. If you are still want to connect with me here is how. www.sequentiasolutions.com/
Have you done any vids where you use if and vlookup to subtract one cell from another such as dr - cr as at the mo I have dr - cr = x and then I vlookup that into another schedule but it would be good if I could have everything in one formula. I have just struggled to find anything in this area.
ruclips.net/video/rYQ9hcMYmik/видео.html this is my latest video using the index and match function. This might be a way to solve what you are after. Or you can do two VLOOKUPs and subtract them inbetween.
Thank you I will have a look later. I tried the 2 vlookup functions and it was a fail as said zero so gave up on that one.
Awesome!
whats that "2" for in the equation? didnt really get that
the 2 is for the column reference since what I want to look up is in column 2. stevechasedocs.wordpress.com/2012/03/28/how-to-use-a-vlookup-in-excel/
I was wondering if you could help me with a formula.
Hey Carlos, Sure would like to try. Please fill out the form on the contact me page of my website and describe the issue you want to solve. www.sequentiasolutions.com/ We could do a Zoom conference if you want later tonight.
I'm stumped!! could I send it to you then you can share ?
sure stevechase@sequentiasolutions.com
@@SteveChase1 thank you. on its way!
no sound....
are your tooth having problem?