Extract Data based on a Drop-Down List selection in Excel

[@trumpexcel]

If you found this video useful, please give it a thumbs up 👍 and subscribe to the channel. Also, let me know what topics you want me to cover in future videos. Here are some other similar videos you may find useful: ✅ Dynamic Filter in Excel - Filter As You Type (with & without VBA) - kzbin.info/www/bejne/rnO1nHasa7eKmac ✅ Advanced Filter in Excel - kzbin.info/www/bejne/kIapdqSgebGAaKs Also, I have made all of my courses available for FREE. You can check these out using the below links: ✅ Free Excel Course (Basic to Advanced) - trumpexcel.com/learn-excel/ ✅ Free Dashboard Course - bit.ly/free-excel-dashboard-course ✅ Free VBA course - bit.ly/excel-vba-course ✅ Free Power Query Course - bit.ly/power-query-course

[@PiyushKumar-wl7py]

Dear sir How can we use same in Google sheet. Pls help me to do this. I am struggling to do same in Google sheet.

[@RijuA1984]

great application , is this workout example sheet available ?

[@trumpexcel]

@@RijuA1984 You can download the file from here: trumpexcel.com/extract-data-from-drop-down-list/

[@trumpexcel]

@@PiyushKumar-wl7py Google Sheets has a FILTER function that can do this. Have a look at this - spreadsheetpoint.com/filter-function-google-sheets/

[@RohinCooper]

how to use helpers with 2 criteria

[@mattj.4533]

I just have to say that I don't leave many KZbin video reviews. But after looking at videos/answers for an interesting Excel problem that I had, I have to say that this is very well done, if you do it step by step. Having somewhat of a programmer background, I overthought this six-ways-from-Sunday... looked at probably 100 other videos... and ended back here. Just do everything like he says. If you can't lock by hitting "F4," type it in. Do it all on one sheet, and if you have to copy the newly-created dynamic table to another sheet, do it at the end. If you have more columns, that's okay; just append to the right of what he displays. It's a really good way around macros if those are the types of things that are blocked at your work, for whatever reason. Nailed it! Thanks man.

[@jameszhe54]

This tutorial is amazing. It's not exactly what I was looking for but it taught me so much and I was able to make some slight adjustments to provide a resolution to our business problem. I was struggling for hours with VLOOKUP, but this did the trick. The screen capture is clear, the instructions precise and easy to follow. Thank you for such high quality content!

[@shujaahmed08]

Please Subscribe me Dear

[@danielk9422]

shut up corona

[@amnielcarlobico417]

This video was able to help me extracting data from 28k rows. The best video I've ever watched.

[@trumpexcel]

Happy to know the video helped :)

[@ChrisAlaimo]

I would love to say this is one of the most helpful excel videos I have ever watched and I have used this multiple times at my job! Thank you!

[@jaffaraalee3720]

I was really looking for this method for few years. But today i came upto this video and it finally ended my search. Now i will start practicing. Thank you so much for this so easy but technical solution.

[@ratnahazra3307]

Extremely helpful and showed multiple excel functions inside one video. It helped me a lot!. Thanks!

[@trumpexcel]

Glad you found it useful Ratna!

[@tommccusker8901]

Very good instructions. I used your idea to develop something i was working on. If i had not found this video, i would not have been able to finish my project. Thank You.

[@subuddhidevapriya3895]

Thank you so much. After hours and hours browsing through different solutions came across your video. Very clear and insightful. Thank you again

[@ajaykumarmujumdar6336]

So far I have referred many videos on Excel as well as VBA from this channel. I liked it very much. Good work and keep me posting.

[@aleenadas2834]

I felt I really should thank you for sharing this. My manager was so impressed by this. Keep doing the good work. Because it is dynamic, it will come handy. Good job!

[@shreyasharma1731]

The best video on internet for this topic. You saved me !!Thanks alot

[@MLG84-94]

This is going to make homeschooling so much easier!!! Thank you!!!!

[@benjaminrice6949]

What a phenomenal solution that can be used in so many circumstances. Thank you for the clear and through explanation!

[@aferg76]

OMG.. I was searching all night for help with this formula. You are the only person I found with a video that made this actually make sense for the average person. Thank you so much. Really impressed.

[@tatepro1]

After 8 years I just stumbled across this video and it was exactly what I needed for a project at work

[@Nigromancy]

I am not going to lie but when i follow along with your video I feel like a genius when it works!!!!!!

[@andrijanastojkovic6838]

This was very helpful! I was trying for a week to make a catalog, I was using all kinds of ways, and finally found this simple one! Thank you very much! I just need to add pictures seperatly

[@jamineminho9834]

THANK YOU SO MUCH, THIS IS SUCH A BIG HELP WITH OUR THESIS COMPUTATION

[@enneasa278]

I was looking for something handy and straightforward, for quite a long time. this one is one of the best. thank you for sharing and for being precise

[@dineshkumar-vr1fr]

Why can't we use filter instead of using all these formulaes

[@alok21prakash]

kzbin.info/www/bejne/mGK2iWetgryAp5I

[@ijnmpi]

Thanks Sumit, although here are various trainers here on youtube but I seem to find your techniques most useful and apt for my requirements. Keep up the good work !

[@MUTHUMASILAMANI]

This is what I was searching for quite sometime. Really explained well. But I need to view few more times to understand each formula. Thanks.

[@deec9200]

Thank you for a very easy to follow tutorial...this video enabled me to accomplish this difficult function quite easily. Much thanks...

[@TheDestroyer8065]

Very clear step-by-step explanation. thank you! SUBSCRIBED

[@jeweljoyventura5919]

Very helpful, and this video was posted 8years ago! Salute sir!

[@akhileshravikumar6910]

This is was SO helpful! I was searching for DAYS to find the correct video. This told me exactly what I needed to do. Thank you SO much!! Continue the awesome work! 😊😊😊

[@darshantayade5066]

You explained it in very simple way. Thanks!

[@sherrywit]

This is very useful. I have a spreadsheet where I select the product category, using your information it now pulls in all the vendors who are in a certain product category. What I would like to do next is have a drop down or data validation that pulls in the returned vendors (from the product category search) in the list. Once I select a vendor it would return that vendor contact information.

[@shubhdeepbatra6568]

Simple & useful for finance & non-finance guys to prepare data models.

[@jawaherath8206]

This is an amazing piece of knowledge. I was thinking about similar usage for preparing a menu costing for a hotel. This gives a new dimension to go forward. Thank you Sumith, May you reveal new ways of doing things in Excel !!!

[@jmathew6988]

Very helpful tutorial. It had the exact answers that I was seeking. Thank you sir.

[@bocanmaria]

Amazing! Mega helpful, very descriptive step by step! I didn't use Excel for a long time and was able to pick up very fast, due to your great explanation! Thank you again!

[@trumpexcel]

Glad you found the video useful!

[@mobarakhossain2287]

what a man you are, really excellent , today I understood excel means excellent. from Malaysia

[@rituakter9225]

Exactly what I was looking for. And your presentation is so good. Very easy to understand. Thank you lot

[@dimokokilala8950]

Exactly what I've been looking for! THANK YOU!!!

[@robertsk1799]

This is a most excellent explanation with intermediate steps very clearly explained. Thanks. The next step would be to indicate how you deal with the dataset expanding or contracting, something that happens often in real life.

[@elizannis]

Thank you so much for this video. super helpful for me. God bless you. thank you again

[@09shirish]

Thanks ! Beautiful extract data on a drop-down list selection......................... thanks sir !

[@sathyanarayanansatagopan9069]

Thank You Very Much! I am eagerly awaiting your video about Excel to XML format to export to tally.

[@redfox14-ffox]

Thank you so much, I would give you an 8 star rating if I could :)

[@7043nz0_h]

This is exactly what I've been looking for, thanks for sharing. Subbed.

[@olivernemo7280]

A wonderfully clear yet detailed project that has helped me enormously, many many thanks.

[@GangGang-qk1se]

This is exactly what I was looking for. Indian tech gods are where I learn my excel info now days lol

[@Allmytravelz7072]

Thanks for this tutorial. I used this today and it worked like a charm. Your video saved me hrs of trial and error in my dashboard. So appreciative. 🙏🏽

[@Aprettybigdeal336]

This video just solved my problem! Thank you so much

[@trumpexcel]

Glad the video helped 🙂

[@christinita4495]

Thank you!! been struggling with how to present this kind of data! such a life saver😅 I've been beating myself coz I dont seem to input any working formula for the result I want and here you are😇🙏🙏

[@iftekharahmad3808]

Superb Bro. It helped me alot. Thank you soo much for your effort.. worth alot.. Thank you and keep the good work up.

[@robparry3772]

Thanks for this video it has helped me understand INDEX, ROWS, and COLUMNS. I have now completed something in excel I have wanted to do for a while and couldn't work it out. Keep up the good work.

[@DaanArt-UK]

This video helped me to put a my Food menu & required items list :) Thanks bro!

[@nsanerydah]

I know I'm late, but a few rewinds and I was able to duplicate your process. Very good work Sir. Keep it up!

[@kaesuma]

Thank you. You have explained it well and quickly. I have a better understanding of ROWS, COLUMNS & INDEX.

[@himanshumalhotra4244]

Very helpful video, great content

[@massivelearn6063]

Really Awesome & Superb, Thank YOU more.... Keep growing..

[@ashishgangwar4393]

Very Nicely and clearly explained. Thank you

[@trumpexcel]

Glad you found the video useful!

[@infinityservicessrl]

Wonderful Job, I was looking forward for this method, but I wanted instead of country using dates, I made the change and it works perfectly. nice thanks man, and thanks God.

[@Family8]

Thank you so much for sharing, this is a very informative, easy to follow video. Very much appreciated :)

[@t.version8985]

Thank you so much Bro!! God bless you for sharing it really helped our team so much!!

[@trumpexcel]

Glad you found it useful :)

[@NahidAkhtarxsoffer]

Such a nice lesson I have ever learned...... Thanks a lot

[@arunmarimuthu1572]

Exactly what I required. Excellent Video, clearly explained Thank you....

[@vaclavnovak8924]

This tutorial is amazing. I love it. Exactly what I was looking for. Thank You so much.

[@NikhilPatil-ug1zr]

thank you so much brother. really helpful for my business.

[@kumarabhilasha4]

I searched 10 previous videos but only this showed me how to get it done!

[@Britt0730808992]

WOW! you are a super teacher bud.

[@dr.forhadslifeevents]

Awesome work with a clear voice!! Thank you Trump!!!!

[@swaroopajosphine2054]

This was very useful fantastic video, thank you

[@chandaatanu]

This is a good alternative for making a manual report instead of using a pivot table.

[@Athousandmyles]

Super useful content! Thank you!

[@LilKaysa]

Perfect!!!! Thanks a lot! I have just subscribed!

[@sivakumars4286]

VERY NICE VIDEO, IT WILL BE WORKING DATE AND TIME FORMAT ALSO, LOT OF THANKS

[@louisesmit4490]

Found all the answers needed in one place. Thank you!

[@TinaThevarge]

Thank you so much for this tutorial and worksheet. This helped me create my dynamic lists in Mac Numbers. I've been fighting with it for a week. Now it just automatically updates. Totally thrilled :D

[@trumpexcel]

Glad the video helped Tina!

[@BlaineCraner]

Thank you! I'm using it for something private and this will help me a lot. :)

[@JenniferKumar-CareerCoach]

Thank you, this was really helpful.

[@anandabherath1009]

Excellent video.

[@tangwh2011]

Excellent tutorial!

[@Amelee55]

Excellent tutorial. Keep up the good work and please publish more Excel tips.

[@carlo81624]

Thanks friend really help me with my work thumbs up

[@osamaal-janabi3230]

Oh man, this exactly what I was looking for. Thanks for sharing.

[@rizwann123]

excellent. many thanks for your effort and for sharing

[@Stepheneastop]

Fantastic, great that you took me from concept to outcome, and I managed multiple sheets and drop-down menus as well.

[@anupjani]

Thanks Sumeet. Just what I was looking for. Though nicely explained "WHAT IS DONE", however since "WHY IS WHAT DONE" was not so clear hence took a while to understand it.

[@nandhinianbazhagan9566]

This tutorial was amazing, it helped me alot. Please keep uploading these videos to people like me to learn Thank you. Will look forward for your other tutorial videos.

[@danielslattery2879]

Great video! Thank you for your help!

[@emily94ru]

That's so useful! Thanks a lot!

[@mikechalupka1846]

This is exactly what I was looking for. Great tutorial. Very simple. Love using Index function.

[@auroreuppa6293]

Thank you so much, extremely useful and brilliant !

[@smartlearningwithrajeshrai]

Thank you so much dear for sharing such a nice and informative video

[@AminMovahhedian]

Great video. Very easy to follow. Thank you.

[@samadkhan-tw4gq]

Thank You So Much dear. It helps me Alot

[@aubreyscreativeworld4395]

Exactly what I needed. This was great!

[@JPrice-uu1og]

Great video!! Thanks a bunch!!

[@nileshmagadum]

Thanks a lot exactly what i was looking for

[@trumpexcel]

Glad you found the video useful!

[@TheCozySpirit]

This was extremely helpful. Excellent tutorial!

[@MrSaqr98]

Thank You so much ... Very simple

[@numandurrani]

Great post, good work, well done...

[@DwithSLR]

After long time problem got resolved. Thank you so much :)

[@yuvrajpardeshi1429]

Simple and So Effective. Thanks a lot for this video. Learnt so much. I was planning to write a VBA program to do this. Excel is great tool

[@fundays4884]

well done ! the best solution

[@rajatv05]

That's an absolute genius! Amazing!

[@keyzersoze5958]

dude this is exaclty what i wanted legend