How to use an excel dropdown list and vlookup to auto-populate cells based on a selection

Excel dropdown list and vlookup to auto-populate cells based on a selection, using:
Data - Select list, Vlookup, named range

[lucas]

wow, in 1 min, the guy solved my 10 hours struggling problem. I was looking into so many videos, none had solutions like yours. Thank you so much

[Rozanne]

Knowledge is power! Thank you so much for this 🙏🏼

[Tinyminyme]

When I saw the length of the video I figured out this was going to be gold. And it was.

[stevied]

Thank you so much for your guidance in this video. Like many others, I was struggling through several other iterations of videos, whereas this one made sense early on. You're a gentleman and a scholar!

[MrtnX]

2020, Just letting you know that your amazing video still is helping people after more tha three years.

[tiffanyb]

I appreciate your straight to the point easy to follow instructions! Thank you so much

[chrisellis]

I am in the same boat as everyone else here, you saved me a ton of time and effort. I messed up a couple times, but once I figured out my own stupidity, it worked wonderfully. Thank you so much for this 1:25 minutes of genius.

[MegaTony]

In 1.26 minutes you explained me what I was looking for in 2 days. Thanks a lot. You deserve a 2 thumbs up.

[beyondthebarre]

i SPENT FOUR DAYS TRYING TO FIGURE THIS OUT. thank you.

[alelascanoc]

Thank you so much for this. I spent most of my day trying to find a solution for my problem and here you have it. You made my day!! Thanks

[vmipsychmajor]

Brief & direct, love it.

Only thing I had issues with was changing spreadsheets before putting the comma after I selected the table range. Gotta select that range, then add the comma, THEN switch back to the right spreadsheet.

Thanks!

[prime]

After finding all these complicated ways to do this I find the most simple way, thank you for this video...

[katiewilson]

Thank you so much for this….. I needed this for project at work. You explained it really well and easy to follow instructions 🎉

[FilmmakingSock]

thank you for saving me from the brink of self harm

[davidbutcher]

Excellent video, clearly explained and exactly what I was looking for, many thanks.

[siobhansmcm]

Thank you! Exactly what I was looking for. Easy to follow.

[ThumbWiggler]

THIS IS THE VIDEO I'VE BEEN LOOKING THANK YOU SO BLESSINGS

[chrism]

Thanks so much for the help! I was beating my head against the wall but your video solved my problem. Cheers!

[wrcchris]

Exactly what I was looking for, very helpful, Thanks

[lmbpros]

Thank you very much for this video. It's clear and concise! I looked through so many videos but I got it on the first try with yours! Cheers!