Awesome!!! Thank You! I love the way you go back to explain and reread the formula in layman's terms. 💯👍🏾
Again, I cant thank you enough. With your help, I have made up this amazing spreadsheet for work, that will pull pictures of products and then use this multiple criteria vlookup to cross reference pricing. It's amazing. SUPER time saver, thanks again SO much :)
I read many posts and videos to fix my vlookup problems but all are not helpful. Your video saved my time! Thank you so much for your sharing!
Very Useful - I finally understood how you used array formula to create virtual helper column, and the speed disadvantages of that.
This was fantastic! I searched the internet with no luck. I tried a lot of nested IF statements, VLookup, XLookup, etc. Your solution was simple and brilliant! Thank you!
THIS WAS INCREDIBLY HELPFUL!!! It helped me created a complete custom formula for data within multiple tables. Thank you so much!!!
Thank you so much for the detail explaination! Really help me with my project.
Thank you for the separator tip! Never would have thought of it.
Great video! So clear and really appreciate the explanations and learned a few tips as a novice excel user I wasn't aware of like the F4 short cut, etc.
Me too. Gr8 video. With this I would recommend a must watch. I found it extremely useful
ua-cam.com/video/UtlYkQCG3uk/v-deo.html
brilliant explanation of the array function. Very, very helpful. Nice job!
Thank-you soooooo much for this video!!!! I've been looking for this explanation for hours! Simple and well explained!!
Nicely explained! Thank you for this 'how-to'.
There is always a possibility of learning new things. Use of seperater was a good idea. I prefer index match over vlookup for dynamic results. Also index can be used in place of choose function. 🙏
Wonderful. Brilliant. Thanks for a clear solution to an ever present problem!
That was so VERT helpful. I am not an expert in Excel but I am OK. I was banging my head against my table top trying to solve this on my own. This was fantastic and saved me so much time. Again A BIG THANK YOU.
for the past 4 hours I have been trying to figure out how to filtered some data and this is the video that offered a viable solution.
Thanks in a million.
Excellent video and use of formula. Thank you for sharing.
That was exactly what I was looking for! Thanks dude!
you made it very simple dear. I tried learning this from some other videos as well, who made it hell lot complicated. Bravo !!
Super helpful! Clear and concise. Thank you so much! :)
I don’t know how to thank you ! You just made my life so easier !! Super thanks
Wow! Would not have thought of using the choose function that way. Fantastic!
Choose is a beautiful function. The logic by the educator is amazing.
A must watch recommendation along with this video.
ua-cam.com/video/UtlYkQCG3uk/v-deo.html
Thank you for explaining it so well. It was a huge help!
How smart you are 🙆🏻♂️ I've seen only the first few minutes and I directly got the brilliant idea 🤩🌷 so smart.. Thank you
This saved me so much time & energy. Thank you SOOO Much!!
Thank you so much.Separated column gave me thorough explanation.Thank you once again
I enjoyed watching this video. Thank you for explaining so we can all understand. I learned something new today.
Very nice and easy way to understand lookup with multiple criteria. Thanks...!!!
even chat gpt couldn't help me out, this tutorial is super class, thank you for sharing
Man!! This is the best thing I learned this year !!! Tks!
You're a lifesaver dude. I can't understand why Microsoft don't have a standard feature for this.
Indeed. Office 365 has thus features I believe.
A must watch recommendation along with this video.
ua-cam.com/video/UtlYkQCG3uk/v-deo.html
Very nice warning about separators and creating unique identifiers.
thank you so much i've been trying to sort out such a formula but i could get it you showed me how... gracias
I had viewed somany videos on excel formulas, but your way of using multiple formulas for similar results is awesome and good explanation and request you to please slow down a bit. All the best.
you're a savior! been trying to find a way for hours.
Super helpful. Was able to do about a weeks worth of work in 5 minutes. Thanks bud.
Amazing video. helped me a lot.
A must watch recommendation along with this video.
ua-cam.com/video/UtlYkQCG3uk/v-deo.html
Thanks so much brother, It was really helpful. I might have watched 15-20 videos. I must say that you video has the best content. Simple and easy. Good Luck..!!
I totally agree. no match.
A must watch recommendation along with this video.
ua-cam.com/video/UtlYkQCG3uk/v-deo.html
Keep producing these great videos! 👍🏻
Hey, muri Chibaba. Great Stuff Leila. You are the best so far on internet.
nice trick combining multiple criteria (columns) into one. simple and effective. kudos.
Very helpful video. Saved me a ton of time. Thank you.
Simply a very Superb way of teaching!! Thank You!!
That was on point and so easy to follow!! Thank you 🙏!!
You are just AMAZING!!! Thank You!!
Very nice explanation and well structured, it was very useful for me! Thanks a lot
I agree. Amazing.
A must watch recommendation along with this video.
ua-cam.com/video/UtlYkQCG3uk/v-deo.html
This video was an absolute blessing! Thank you so much for sharing. :D
You are a life saver. Thanks so much!
Thank you, this was really helpful
Amazing to learn something new and its really creative and good application of mind with knowledge of excel, God Bless You
THIS WAS INCREDIBLY !!! It helped me . Thank you so much!!!
Yeah amazing. U can add on this 1 as well. I found it very useful.
ua-cam.com/video/UtlYkQCG3uk/v-deo.html
thanks for your video clip, as its still i have some issue about how to fix the symbol key for (I)separation ,please let me know which short cut key for separation. thank you so much.
thank you you saved me a lot of work
this is very useful & best guidance.
You are the best. You saved my life :)
Excellent Presentation. Thank you.
Saved a lot of time for me. Thanks
Awesome tutorial, thank you!
this video helped me a lot. thank you very much
no doubt your videos are great, but I found this approach a bit complex. I did the same with below pasted formula...hope this helps some one else too...run this formula in F3 and you are good to go:-
INDEX($C$2:$C$9,MATCH($E3&F$2,$A$2:$A$9&$B$2:$B$9,0))
This is a great idea! Thanks a lot, it helped me a lot
Very nicely explained and very helpful. Thank you
Nicely done, just subscribed. Thanks!
Yeah I agree. Gr8.
A must watch recommendation along with this video.
ua-cam.com/video/UtlYkQCG3uk/v-deo.html
Hi, i have a table with 3 columns: 1-designation, 2-steps (1 to 6) and 3-Salary, I used the dropdown list to select the first 2 options, and I am not sure which formula to use to get the salary in the third column pertaining to the first two options. Appreciate your help. Thanks
Awesome!! helped me much! actually a pretty brilliant but simple solution
Brilliant one. Helped me a lot.
A must watch recommendation along with this video.
ua-cam.com/video/UtlYkQCG3uk/v-deo.html
Excellent video!! I am very grateful!
so simple and perfect!!!
Brilliant thank you!
Thanks a lot . Save my lot of time
Thanks you man !! You are my livesaver!!!!
You're channel name is exactly named what it delivers awesome 🎉!!!
Very helpful. Thank you!
Excellent explanation in details
Excellent video!
Thank your very much It is very helpful for me
THANKS A LOT! REALLY HELP MY WORK
Thanks, ;) it's very useful.
Blew my mind!
Nesting Choose function with Vlookup was awesome.
its very useful.... thanks a lot
Great video! Thank you!
Very useful. Thank you so much 🙂
Thank you that was very helpful
Thanks for the detailed explanation, very helpful.
My only question would be how to avoid getting #N/A in the cells that have no data yet when you paste it to all the cells.
Dude, that was so smart. was trying nested vlookups and getting no where. the helper cell was simple and effective
Very useful and excellent video
Appreciate ur work. The video is pretty explanatory.
Can u plz advice how will you approach this formula if you did not have the Exam header. Then you will be left with only Name and Math header...any ideas ?
Thanks for the video
Amazing help, thanks!!!
Excellent Video. thank you.
Super astuce.merci
Thank u so much i required exactly this information
Good video. These days I just use powerquery to do this as it is more repeatable.
Thanks so much. Such a big help
Best video in this matter❤❤
Thanks so much for this.
I have watched over 10 videos to get multiple criteria charts to VLOOKUP correctly with ZERO luck. Your video and instructions work on the first try. I am beyond grateful. This is going to save me at least 10 minutes of work every morning. THANK YOU!
Me too. I’ve watched quite a few and This Will save me hours and hours of work! So awesome! Thank you!