Using Excel VLOOKUP Function with Multiple Criteria (Multiple Cells)

[@abenachelmotta451]

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!

[@jennes1442]

Me too. I’ve watched quite a few and This Will save me hours and hours of work! So awesome! Thank you!

[@ursofranc]

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!

[@davidsmalling3278]

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.

[@trumpexcel]

Glad you found it useful David!

[@phkhald]

How smart you are 🙆🏻‍♂️ I've seen only the first few minutes and I directly got the brilliant idea 🤩🌷 so smart.. Thank you

[@mandy34061]

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!

[@misskia22]

Awesome!!! Thank You! I love the way you go back to explain and reread the formula in layman's terms. 💯👍🏾

[@vegetabulls278]

You're a lifesaver dude. I can't understand why Microsoft don't have a standard feature for this.

[@SIMRANKAUR-eg7nc]

Indeed. Office 365 has thus features I believe. A must watch recommendation along with this video. kzbin.info/www/bejne/i6XPip6HeKxmq80

[@shafkathussain4243]

Index match

[@TheNbfiddlehead]

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 :)

[@glennlancaster1443]

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.

[@TNVDPrasad]

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.

[@Lone_wolf_31]

I don’t know how to thank you ! You just made my life so easier !! Super thanks

[@lisaschneer1398]

This saved me so much time & energy. Thank you SOOO Much!!

[@joshzeus19]

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..!!

[@SIMRANKAUR-eg7nc]

I totally agree. no match. A must watch recommendation along with this video. kzbin.info/www/bejne/i6XPip6HeKxmq80

[@booneellis3404]

Super helpful. Was able to do about a weeks worth of work in 5 minutes. Thanks bud.

[@SIMRANKAUR-eg7nc]

Amazing video. helped me a lot. A must watch recommendation along with this video. kzbin.info/www/bejne/i6XPip6HeKxmq80

[@socialitenerd]

THIS WAS INCREDIBLY HELPFUL!!! It helped me created a complete custom formula for data within multiple tables. Thank you so much!!!

[@knowledgelover2736]

Dude, that was so smart. was trying nested vlookups and getting no where. the helper cell was simple and effective

[@trumpexcel]

Thanks for commenting David... Glad you found the video useful!

[@Barhomopolis]

Thank you for the separator tip! Never would have thought of it.

[@smithe53]

Wow! Would not have thought of using the choose function that way. Fantastic!

[@SIMRANKAUR-eg7nc]

Choose is a beautiful function. The logic by the educator is amazing. A must watch recommendation along with this video. kzbin.info/www/bejne/i6XPip6HeKxmq80

[@vinaynagaonkar8592]

Amazing to learn something new and its really creative and good application of mind with knowledge of excel, God Bless You

[@photogenic305]

I enjoyed watching this video. Thank you for explaining so we can all understand. I learned something new today.

[@unnikrishnansanthosh]

even chat gpt couldn't help me out, this tutorial is super class, thank you for sharing

[@sarminsultana4310]

Oh my God ! this video made me hero at my office.

[@trumpexcel]

Yayy.. happy to know this 🙂 Glad the video was helpful

[@rajangoyal9234]

you made it very simple dear. I tried learning this from some other videos as well, who made it hell lot complicated. Bravo !!

[@tamaragintrand9534]

Thank-you soooooo much for this video!!!! I've been looking for this explanation for hours! Simple and well explained!!

[@SebAnt]

Very Useful - I finally understood how you used array formula to create virtual helper column, and the speed disadvantages of that.

[@giselecandido8909]

Man!! This is the best thing I learned this year !!! Tks!

[@drajune]

you're a savior! been trying to find a way for hours.

[@nikhatkamal8908]

Simply a very Superb way of teaching!! Thank You!!

[@edgeagle]

Your Examples were Awesome , thank you so much 👌

[@trumpexcel]

Thanks for commenting... Glad you found the video helpful 🙂

[@narayanmeena5419]

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. 🙏

[@basattayfun1666]

nice trick combining multiple criteria (columns) into one. simple and effective. kudos.

[@brenna-lea1294]

This video was an absolute blessing! Thank you so much for sharing. :D

[@karthiselvenp5793]

Got the result at 1st try… thanks much 😊

[@trumpexcel]

Glad it helped

[@spat21]

@@trumpexcel If values from 3 or more columns to be matched using Vlookup , can the same helper column method be applied?

[@AR-ou8il]

That was on point and so easy to follow!! Thank you 🙏!!

[@thedrtamergouda]

Saved a lot of time for me. Thanks

[@tinashedzapasi5480]

Hey, muri Chibaba. Great Stuff Leila. You are the best so far on internet.

[@MDSHAMIAHMAD-n7o]

Just Awesome buddy... Keep growing ❤

[@premjeetgupta90]

Very nice and easy way to understand lookup with multiple criteria. Thanks...!!!

[@uditsharma5142]

Very helpful video. Saved me a ton of time. Thank you.

[@shrivatsa4090]

You're channel name is exactly named what it delivers awesome 🎉!!!

[@OzduSoleilDATA]

Very nice warning about separators and creating unique identifiers.

[@OzduSoleilDATA]

Very clever explanation for using the separator.

[@trumpexcel]

Thanks Oz :)

[@mostafaelsharef9551]

Best video in this matter❤❤

[@jenniferandrews5914]

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.

[@SIMRANKAUR-eg7nc]

Me too. Gr8 video. With this I would recommend a must watch. I found it extremely useful kzbin.info/www/bejne/i6XPip6HeKxmq80

[@anand20002]

Excellent Presentation. Thank you.

[@manasipatil8279]

Really very informative and helpful video.Easy to understand.Great!!

[@trumpexcel]

Thanks Manasi... Glad you found the video helpful 🙂

[@anitab6436]

Thank you so much for this! You solved my problem! 😊

[@trumpexcel]

Glad the video helped 🙂

[@mavillalobos]

Very nice explanation and well structured, it was very useful for me! Thanks a lot

[@SIMRANKAUR-eg7nc]

I agree. Amazing. A must watch recommendation along with this video. kzbin.info/www/bejne/i6XPip6HeKxmq80

[@excellence_is_me]

You are the best. You saved my life :)

[@joycegarcia5489]

Super helpful! Clear and concise. Thank you so much! :)

[@benedictojason7457]

THIS WAS INCREDIBLY !!! It helped me . Thank you so much!!!

[@SIMRANKAUR-eg7nc]

Yeah amazing. U can add on this 1 as well. I found it very useful. kzbin.info/www/bejne/i6XPip6HeKxmq80

[@RedROX01]

Worked liked a charm. ❤

[@lovinpunjabi]

Very nicely explained and very helpful. Thank you

[@sehrishimran2999]

You are a life saver. Thanks so much!

[@leonardomarchetti6003]

Awesome tutorial, thank you!

[@storeboughtlowcarbketoprod1377]

Excellent video!! I am very grateful!

[@SanthoshKumar-mb3wr]

Thank you so much.Separated column gave me thorough explanation.Thank you once again

[@AhmSae4333]

This is a great idea! Thanks a lot, it helped me a lot

[@masoodali4968]

this video helped me a lot. thank you very much

[@acjunk]

Thank you for explaining it so well. It was a huge help!

[@akramnajjar]

Wonderful. Brilliant. Thanks for a clear solution to an ever present problem!

[@ProviderKnowledge]

It's crucial. Thank you, sir

[@sherryazuma139]

Thank you so much for the detail explaination! Really help me with my project.

[@ZeeshanKhan-pj8zt]

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 ?

[@ravisankarvenkataraman6640]

Very good teaching . But , can this helper column be replaced by concatenation ? .

[@ConsulthinkProgrammer]

Alternative with concatenate: kzbin.info/www/bejne/eXy5hZSApph1aM0

[@amz4648]

Thanks you man !! You are my livesaver!!!!

[@mameichannel]

THANKS A LOT! REALLY HELP MY WORK

[@rajeshshah6758]

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

[@udayteja6595]

Nesting Choose function with Vlookup was awesome.

[@josephthibault6999]

Good video. These days I just use powerquery to do this as it is more repeatable.

[@ihtshamjamil9718]

Thanks for Explaining Step by step for easy understanding. Please also Guide me how do we use function in above situation because i have different condition i need cumulative values of all these condition . please guide how to use sum function or sum if function in above condition

[@MahmoudAlElaimi]

Brilliant Manner, Big thanks

[@ChristWinningChannel]

This is genius, eish.. thank you so much

[@SIMRANKAUR-eg7nc]

Totally true Amazing video learn a lot. A must watch recommendation along with this video. kzbin.info/www/bejne/i6XPip6HeKxmq80

[@danielb8982]

Awesome!! helped me much! actually a pretty brilliant but simple solution

[@SIMRANKAUR-eg7nc]

Brilliant one. Helped me a lot. A must watch recommendation along with this video. kzbin.info/www/bejne/i6XPip6HeKxmq80

[@thomassun6737]

Very helpful. Thank you!

[@amaankhan2775]

Thanks a lot . Save my lot of time

[@sharmilisen2926]

Very useful. Thank you so much 🙂

[@hooverbean]

brilliant explanation of the array function. Very, very helpful. Nice job!

[@rupeshthakur9094]

Super helpful, How to get multiple value lookup in single cell in Microsoft excel 2013 ?

[@djamelbek7506]

Thank your very much It is very helpful for me

[@CreativeWorldbyAbial]

very helpful for me thanks for sharing

[@ConsulthinkProgrammer]

Vlookup: if there more than one lookup_value, alternative with concatenate kzbin.info/www/bejne/eXy5hZSApph1aM0

[@frankyfernandes6283]

I am a teacher and have started working on school data. Came here looking for a formula that can help me. Though this demonstration is not exactly what I am looking for at this time, it is a good video. Appreciate! I am looking for a Formula that can help me count on Boys who got different grades. The gender column has boys and girls. And there is the Grade column for each Term. I want the formula to look up for only boys and count how many boys got A, B C etc Grades.

[@Jyotika4]

Excellent video!

[@ahmed90006]

Excellent explanation in details

[@robertseymour9217]

Great video! Thank you!

[@arkd3um1988]

Very nice and thank you. Best regards

[@suhasthonge6816]

Thank u so much i required exactly this information

[@andiasog5308]

thank you you saved me a lot of work

[@ANJO0909]

Thanks so much. Such a big help

[@b0n3zy]

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.

[@scottnicholls-ytacc2190]

Just use IFERROR around that whole formula?

[@JM-eq3sx]

Nicely done, just subscribed. Thanks!

[@SIMRANKAUR-eg7nc]

Yeah I agree. Gr8. A must watch recommendation along with this video. kzbin.info/www/bejne/i6XPip6HeKxmq80

[@akshaychavan9101]

Most valuable formula

[@gauudi8230]

Keep producing these great videos! 👍🏻

[@eshakdossaji1506]

Excellent video and use of formula. Thank you for sharing.

[@vpolexic]

Amazing help, thanks!!!

[@kumarraja5688]

Excellent Video. thank you.

[@anishchhabra6085]

Awesome bro, thank you so much!

[@anantsharma5862]

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))

[@JunAgruda1]

¡Bravo y gracias amigo! But please present yourself next time so that anyone helped by your lecture will know who to thank for.

[@SIMRANKAUR-eg7nc]

Yeah .The man is brilliant. A must watch recommendation along with this video. kzbin.info/www/bejne/i6XPip6HeKxmq80

[@vest98april94]

Thank youu so muchh sirr, god bless you