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!
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!
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.
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 :)
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.
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..!!
Choose is a beautiful function. The logic by the educator is amazing. A must watch recommendation along with this video. ruclips.net/video/UtlYkQCG3uk/видео.html
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.
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. 🙏
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.
How i get data if i have following condition. For eg. I have 100 employee working in my Factory. I want to look there particular day production, that day wages, that day work time, so i combine thid data just changing by date in sheet.???
Sir, This video was very helpful. I have been trying since 2 days to find a solution to a problem. This video has helped me partly. If a get an error I want the cell to be blank. I tried iferror function but in some cases where the data is choosen it shows them also as blank. I need your help to rectify this error if possible
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 ?
this was actually helpful, but I am facing an issue, a relative reference not working after entering the array function, when I copy down the array function after CTRL+SHIFT+ENTER, and drag the formula to other cells, cells get fixed absolute reference, and all the output appear same as the one is first cell. can you please, suggest a way how to solve this issue. Thank you.
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!
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!
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.
Glad you found it useful David!
How smart you are 🙆🏻♂️ I've seen only the first few minutes and I directly got the brilliant idea 🤩🌷 so smart.. Thank you
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.
ruclips.net/video/UtlYkQCG3uk/видео.html
Index match
Thank you for the separator tip! Never would have thought of it.
I don’t know how to thank you ! You just made my life so easier !! Super thanks
Awesome!!! Thank You! I love the way you go back to explain and reread the formula in layman's terms. 💯👍🏾
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!
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 :)
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.
This saved me so much time & energy. Thank you SOOO Much!!
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.
ruclips.net/video/UtlYkQCG3uk/видео.html
even chat gpt couldn't help me out, this tutorial is super class, thank you for sharing
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.
ruclips.net/video/UtlYkQCG3uk/видео.html
Dude, that was so smart. was trying nested vlookups and getting no where. the helper cell was simple and effective
Thanks for commenting David... Glad you found the video useful!
Oh my God ! this video made me hero at my office.
Yayy.. happy to know this 🙂 Glad the video was helpful
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.
ruclips.net/video/UtlYkQCG3uk/видео.html
THIS WAS INCREDIBLY HELPFUL!!! It helped me created a complete custom formula for data within multiple tables. Thank you so much!!!
Your Examples were Awesome , thank you so much 👌
Thanks for commenting... Glad you found the video helpful 🙂
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.
Amazing to learn something new and its really creative and good application of mind with knowledge of excel, God Bless You
I enjoyed watching this video. Thank you for explaining so we can all understand. I learned something new today.
Simply a very Superb way of teaching!! Thank You!!
Man!! This is the best thing I learned this year !!! Tks!
you're a savior! been trying to find a way for hours.
Saved a lot of time for me. Thanks
This video was an absolute blessing! Thank you so much for sharing. :D
Hi, I have a product catalogue with tech specs. I want to input the specs and let excel pick the product Model . How do we do that ?
Got the result at 1st try… thanks much 😊
Glad it helped
@@trumpexcel If values from 3 or more columns to be matched using Vlookup , can the same helper column method be applied?
nice trick combining multiple criteria (columns) into one. simple and effective. kudos.
Just Awesome buddy... Keep growing ❤
Very Useful - I finally understood how you used array formula to create virtual helper column, and the speed disadvantages of that.
Thank you so much for this! You solved my problem! 😊
Glad the video helped 🙂
you made it very simple dear. I tried learning this from some other videos as well, who made it hell lot complicated. Bravo !!
Very helpful video. Saved me a ton of time. Thank you.
You are the best. You saved my life :)
That was on point and so easy to follow!! Thank you 🙏!!
Worked liked a charm. ❤
Thank-you soooooo much for this video!!!! I've been looking for this explanation for hours! Simple and well explained!!
Very nice and easy way to understand lookup with multiple criteria. Thanks...!!!
Very clever explanation for using the separator.
Thanks Oz :)
You're channel name is exactly named what it delivers awesome 🎉!!!
Best video in this matter❤❤
Awesome tutorial, thank you!
Excellent Presentation. Thank you.
Very nicely explained and very helpful. Thank you
You are a life saver. Thanks so much!
Really very informative and helpful video.Easy to understand.Great!!
Thanks Manasi... Glad you found the video helpful 🙂
This is a great idea! Thanks a lot, it helped me a lot
Excellent video!! I am very grateful!
It's crucial. Thank you, sir
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.
ruclips.net/video/UtlYkQCG3uk/видео.html
Very nice warning about separators and creating unique identifiers.
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. 🙏
THANKS A LOT! REALLY HELP MY WORK
this video helped me a lot. thank you very much
Thanks you man !! You are my livesaver!!!!
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.
ruclips.net/video/UtlYkQCG3uk/видео.html
Brilliant Manner, Big thanks
Super helpful! Clear and concise. Thank you so much! :)
Will Choose fn work for 3 or more criteria ?
But placing Choose{1,2,3} ?
Pl guide as I have a data set to lookup 5 or 6 criteria to get the match.
Very helpful. Thank you!
Thank you so much.Separated column gave me thorough explanation.Thank you once again
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.
ruclips.net/video/UtlYkQCG3uk/видео.html
This is genius, eish.. thank you so much
Totally true
Amazing video learn a lot.
A must watch recommendation along with this video.
ruclips.net/video/UtlYkQCG3uk/видео.html
Very good teaching . But , can this helper column be replaced by concatenation ? .
Alternative with concatenate:
ruclips.net/video/CKVTaJq3B2k/видео.html
Thank you for explaining it so well. It was a huge help!
Hey, muri Chibaba. Great Stuff Leila. You are the best so far on internet.
Very useful. Thank you so much 🙂
Thanks a lot . Save my lot of time
Thank you so much for the detail explaination! Really help me with my project.
Excellent video!
Great video! Thank you!
Hi what if you have right table data and you need map to left side
Can you explain how to do this if the arrange of data is a pivot table
Wonderful. Brilliant. Thanks for a clear solution to an ever present problem!
very helpful for me thanks for sharing
Vlookup: if there more than one lookup_value, alternative with concatenate
ruclips.net/video/CKVTaJq3B2k/видео.html
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
ruclips.net/video/UtlYkQCG3uk/видео.html
Amazing help, thanks!!!
Thanks so much. Such a big help
Matt's Mid Term is the lowest score among his Final and Unit test (53). Is that possible if I want to find that value using Vlookup? Thank you.
You are my hero!
Amazing talent.
A must watch recommendation along with this video.
ruclips.net/video/UtlYkQCG3uk/видео.html
Excellent Video. thank you.
Nesting Choose function with Vlookup was awesome.
Super helpful, How to get multiple value lookup in single cell in Microsoft excel 2013 ?
How i get data if i have following condition. For eg. I have 100 employee working in my Factory. I want to look there particular day production, that day wages, that day work time, so i combine thid data just changing by date in sheet.???
Sir, This video was very helpful. I have been trying since 2 days to find a solution to a problem. This video has helped me partly. If a get an error I want the cell to be blank. I tried iferror function but in some cases where the data is choosen it shows them also as blank. I need your help to rectify this error if possible
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 ?
Good video. These days I just use powerquery to do this as it is more repeatable.
Thank your very much It is very helpful for me
Excellent explanation in details
Thank u so much i required exactly this information
thank you you saved me a lot of work
Can’t you use the AND function in the lookup value argument so it matches two (or more) criteria?
Alternative concatenate with "&"
ruclips.net/video/CKVTaJq3B2k/видео.html
this was actually helpful, but I am facing an issue, a relative reference not working after entering the array function, when I copy down the array function after CTRL+SHIFT+ENTER, and drag the formula to other cells, cells get fixed absolute reference, and all the output appear same as the one is first cell. can you please, suggest a way how to solve this issue. Thank you.
I watched and followed all your instructions but On copying Formula BOb only his unit test is edited remaining cells ? Not copied
Can this formula work in VBA as I am trying to create a school fee receipt based on your video but the formula doesn't seem to work in VBA?
Awesome bro, thank you so much!
How to use this multipre criteria vlookup just the second criteria to be different than the values in the cell?
Thank you in advance!