How to Auto-Populate Fields in Excel Using a Drop-Down and VLookup in Excel

In this video, I show you how to insert a drop-down box in an order form in Excel and use VLookup to auto-fill the contact info fields. This is a great way to select a customer number and have all of the address fields auto-fill. It's pretty simple once you get the hang of it!
Don't forget to subscribe to my channel for more tutorials!
Video recorded using Screencast-O-Matic (www.screencast-o-matic.com)
Thanks for tuning in!

[@AsheramK]

Annoyingly enough I found this just _after_ I had learnt about validation and VLookup, but this is a much more concise and easier-to-follow explanation than what I had to sit through. Have an upvote.

[@karthikshetty3162]

Seriously Vlookup is that easy. thank you so much until now u have been the only to explain vlookp in such a simple way..

[@SimpleSoftwareTutorials]

Glad I was able to help you. Thanks for your feedback!

[@greenXXV]

After searching for a couple hours your video was the only one that helped, thanks!!

[@joshuamkoehn]

Thank you, thank you, thank you. I've spent the past 2 hours trying to figure out how to do this. Your video was extremely helpful and easy to follow. You're a lifesaver!

[@atheos7965]

I've been through a lot of videos, but none have been this instructional. Not only that, but you're voice is also very pleasant. You've helped me a ton, thank you!

[@traciedwards7449]

So HAPPY I stumbled across this video today. You explained everything very well and I now feel confident that I can do what I need to do. Thank you!!

[@tstevieg]

I finally found someone to help after days of searching! Thank you for this

[@mohsinfareed1797]

Thanks very much for the very clear and well explained Vlookup. With your example, I now could figure out how and way to use it. Great.

[@rebeccaash8542]

This is the formula I have been looking for forever! You just saved our department a ton of time! Thank you!

[@SteveSladovnik]

NAILED it! Thank you very much for this tutorial. I found you after struggling through at least 25 other videos. Your explanation was clear and concise! Thanks again!

[@kirstenguffey4209]

THANK YOU! I have been trying to figure out how to do this for over a month. I can finally easily convert project numbers to our new numbering system.

[@Suamarcos]

Thank you! This was extremely helpful!! Clear and concise! 🙌🏽

[@DrPatrickKingsep]

Thank you. Well described. Your description of what I found quite difficult to figure out, and I didn't until I found your video, was most helpful. Very much appreciate this!

[@VibeVixen02]

This was the fastest, most succinct solution video I’ve found on this topic. Thank you so much!!

[@michellethacker7518]

This helped me so much! Thank you for saving me time and a major headache!

[@CAVIKRAMSHANKARMATHUR]

Awesome and so easy to understand!

[@billkastens8177]

You are a life saver! Thank you so much for posting such a useful video lesson. I did not get it at first until I noticed the look up column has to be the the first column in the lookup sheet. Otherwise it does not work.

[@The80sBoy]

So very useful. Thank you again Sally, keep up the brilliant work.

[@gabrielthemessenger]

Incredible Tutorial - Thank you so much!

[@jameschamberlain9440]

Very well done. Best explanation I have seen on the internet. You made it very easy. Thank you!!

[@marlinabasir]

I was looking for this!!! Omg I'm so happy.i wasn't sure what it's called so im just glad to find this.need it for my new work.thanks a lot for sharing

[@cynellekhentannvasquez8219]

thank you so much! i've been googling all night for this finally found it!

[@TheRipeTomatoFarms]

Best tutorial on Vlookup and autopopulate I've seen!

[@adexteriors2092]

Thank you so much for this! It was the only video that really showed what I needed :) So very helpful!

[@aarjav22]

Precise and to-the-point. Thank you.

[@elibarikimakundi1602]

I have been looking for this technique for 2 year, be blessed,

[@Kev1984Madden]

Thanks this video is super helpfully. Looking for this type of info for hours. Now im going to use dynamic dropdrown list and vlook up and save it as a webpage. 🙂

[@mahanmashoof1989]

Took an hour to find your video..exactly what I was looking for! Thanks a lot :)

[@Bansilaal1613]

I had watched so many videos but your video is Easy to understand and is very very helpful for me.. thanks a lot !!

[@billkingdom5038]

Brilliant... Thank you.. very easy to follow and bang on.. Thank you

[@maxpock]

Thanks a lot! like many others said below, after a long time I found your video which solved the issue I was having.

[@beefen7921]

Great tutorial and show/tell! thank you!

[@reystephengnamia]

Finally found this video for data validation and vlookup. Massive help.

[@paulvairo6334]

Thank you. this helped so much. I finally got it to work.

[@amantukrel]

Thank you so much! This was really helpful.

[@judewakefield7213]

Very useful, solved a difficult problem I was having!

[@marilynburgos2381]

Thank you for this information, you have no idea how much it was needed today :)

[@nuurunnuhabtmdhattakpm-gur2127]

Thanks a million. May God bless you always. Love from Malaysia

[@Locutius11]

What a great and helpful video. Clear and on point. this has saved me hours....Thank you Sally.

[@SimpleSoftwareTutorials]

Thanks for the feedback!

[@MrMarufRashid]

Its a great video...So useful. Thank you again Sally, keep it up...

[@seilservice]

I should really thank you for solving a huge issue :) Thanks for this very good video !!

[@tazeemismail3566]

Many thanks for sharing. Much appreciated.

[@wangzig9800]

Thank you so much! you are great! Bless you.

[@doraandfamily3628]

THANK YOU SOOO MUCH!VERY EASY TO FOLLOW TUTORIAL :)

[@danielcarrasco8329]

YOU ARE A LIFESAVER!!! THIS WAS AMAZING!

[@emansimango]

Thank you...Very much, finally what i was looking for : )

[@GuilleFunes_]

Man, I love you, I always wanted to do this. This will save me tons of time. GRACIAS

[@RealEnglishNow]

THANK YOU! THIS IS EXACTLY WHAT I NEEDED!!!!!!

[@dewaynerudder5200]

Thank you! This was a very helpful tutorial.

[@nico72ify]

Awsome, Thank You this is a great video!!!!!!!!

[@tamarajelinek1964]

Amazing help. Thank you !!

[@willierollerskating8642]

Hi Sally! Thank you so much for your Video! It was so HELPFUL! Now I know how to use VLOOKUPS!! : ) The other courses does not explain "As Hands On" as you did. Congrats! I subscribed to you as well! I will refer my friends to your trainings! Take care! : )

[@marioosh80]

Awesome! Many thanks for this.

[@hussienabood2232]

Excellent and remarkable learning video, thank you for your magnificent efforts.. Fantastic explanation.

[@basedave1000]

Extremely awesome

[@ingridlietz9404]

Awesome. ..been looking for this... thank you!

[@puthuval1]

Thanks, really looked for this one, many thanks,

[@rummysandhu1232]

Thank you, it is very helpful and very clear instructions,

[@SheNotes]

THANK YOUUUU OMG THIS IS WHAT IVE BEEN LOOKING FOR

[@hdeen4610]

I thank you !!!This was so helpful

[@sheilawilson6809]

Wow, this is perfect for what I needed.

[@deepaksurana2538]

Hey Sally, I liked the video, simple and easy to understand, i have a daily log book of material received and i have a daily material receive/consumption as per site book, i want to use data validation for date wherein i can choose the date and it shows me the record of material received and consumption in a single sheet. I have two different sheet of the material received and consumption.

[@matty2889]

Thanks so much, Sally! This was really helpful :)

[@JPMI1313]

Nicely described. Thanks

[@muhammadaftab332]

Awesome & easy to get

[@shetkar911]

u have no idea how much this helped me. thanks a lot :)

[@skrlikes1]

Superb and simplistic....great mam

[@philturk]

Awesome tutorial, thanks

[@andreasdoerr5342]

Sally... Thank you so much.. really saved my mental stability :D :D :D

[@jasononeill8740]

Very useful - Thank you Ali

[@nguyen3276]

Great video! I learned how to do this and then learned how to use the MATCH function to make the column index dynamic. Saved me a load of time after setting it all up!

[@randomrandy3059]

So is the Match function better than VlookUp? Im trying to understand the differences.

[@nguyen3276]

@@randomrandy3059 It depends on what you're doing and personal preference. But you can use them together. Basically, as long as you're headers are the same, you'd be using the MATCH function to find the column index number for you. I do find that I've been using a combo of INDEX and MATCH more frequently. Keep learning, once you get the hang of it, you'll want to move onto other ways to do the same tasks faster (depending on how much data you're working with).

[@randomrandy3059]

@@nguyen3276 Cool. I can't wait to understand more. I have since gotten the hang of index and match, but im finding xlookup to be more convenient, but then I have to come back to index and match. It confusing at first, but like you say "Keep learning...." quick run down, I've hosted a football pool for 5 years after this season. I've always used numbers because it was simple. I knew about Excel but never bothered to get into it because, well, I thought Excel was very complex for something so simple that I was doing. A few months I decided to cross over, forcing myself to use and learn excel during the season, and man how mind opening it was for me. I started looking at my simple football pool and it was alot of work. Now im building a system to automate alot of things, and really make simple. Anyhow, thank you, and have a good day.

[@DariuszKrak]

youre amazing thank you for the content.

[@mani220285]

THANKS FOR YOUR INFORMATION ITS REALLY HELPFULL FOR WORK

[@Edenboneil13]

Thank you so much, this video was very helpful! I was wondering if there is a way to auto-populate with multiple selection drop-downs. Once I select two drop-downs within the same cell, I get an error message in my auto-populated cells. I'm using this as a tracker, and would like to have the option to select multiple items from the drop downs to avoid having too many cells.

[@an3404]

I love the way u explain n help ... Thumbs up n subscribed

[@pacifictransit1143]

Thanks for the help.

[@kherdin19]

Exactly what am looking for 🔥

[@s.mflemban9400]

really you saved my day! thanks alot

[@jamesthang8646]

Thank you for your help

[@rewphixer]

Nothing I can say other than THANK YOU exactly what I needed I appreciate you taking the time so I have only 1 way I know how to repay by a great comment. AAAAA++

[@SimpleSoftwareTutorials]

Thanks so much, I appreciate your feedback!

[@shadricksiame5741]

Great presentation

[@homatenindilula2550]

You are a lifesaver. Thanks so much for this

[@SimpleSoftwareTutorials]

Glad it was helpful to you!

[@N7eptune]

Thank you! I created a dynamic list of customer’s names and used this as my drop-down box. I used vlookup for the remaining data but found I had to limit the range.

[@indeed38]

This was helpful Thank you :)

[@bolajokoewebajo5603]

Thanks, it was helpful

[@lukasibanda6730]

Great tutorial Sally Ulianich

[@poormanshobby7604]

This made the anxiety bubble in my head deflate. Thank you

[@bruceAW1]

You are my hero!!!

[@stuartheywood5975]

THANK YOU SO MUCH!!!!!!

[@arlynraymundo452]

Time saving tips👌🏼

[@leeingraham2767]

Hey Sally, thanks for the great video! It answered most of my questions very well, but I do have an additional question that would take this tutorial a step further. I have a sheet used to create user rights on RFID chips. Most instances can be taken care of by using a table referencing the rights to the job type (Vlookup), however, sometimes I need to break from that set table and create a custom set of rights. Is there anyway I can do a custom field entry on a vlookup cell without adding it to the table? Thanks in advance and I look forward to hearing from you.

[@byronj.guevaralopez3515]

I like how you teach :)

[@robertstemple6641]

Great Video!!

[@fushonathan]

Thank you so much.

[@littleshyboy6010]

thank god, it helps me alot

[@anitajones184]

Thank you!!!! Thank you!!!!

[@mistahaych9552]

Thank you!

[@richardnaylor910]

Thank You !

[@greginky]

Fantastic video. This is exactly what I was looking for. I do have a question for something that I would like to do. Can you show how that I can make a number that is in a drop down list show as a different color than all the others in the same drop down list so that it is easier to find than all of the black numbers. I want it to stand out so that I can find it quickly.