How to Auto-Populate Fields in Excel Using a Drop-Down and VLookup in Excel
HTML-код
- Опубликовано: 2 июл 2024
- 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! - Хобби
Seriously Vlookup is that easy.
thank you so much until now u have been the only to explain vlookp in such a simple way..
Glad I was able to help you. Thanks for your feedback!
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.
Superb and simplistic....great mam
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++
Thanks so much, I appreciate your feedback!
Exactly what am looking for 🔥
Best tutorial on Vlookup and autopopulate I've seen!
After searching for a couple hours your video was the only one that helped, thanks!!
Finally found this video for data validation and vlookup. Massive help.
I finally found someone to help after days of searching! Thank you for this
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!!
Thank you! This was extremely helpful!! Clear and concise! 🙌🏽
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!
really helpful...great and your voice is also nice!!
Thank you!
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.
This is the formula I have been looking for forever! You just saved our department a ton of time! Thank you!
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!
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!
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.
Incredible Tutorial - Thank you so much!
So very useful. Thank you again Sally, keep up the brilliant work.
Awesome and so easy to understand!
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!
THANKS FOR YOUR INFORMATION ITS REALLY HELPFULL FOR WORK
This helped me so much! Thank you for saving me time and a major headache!
This was the fastest, most succinct solution video I’ve found on this topic. Thank you so much!!
thank you so much! i've been googling all night for this finally found it!
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
Thank you so much for this! It was the only video that really showed what I needed :) So very helpful!
Precise and to-the-point. Thank you.
I have been looking for this technique for 2 year, be blessed,
Very well done. Best explanation I have seen on the internet. You made it very easy. Thank you!!
Took an hour to find your video..exactly what I was looking for! Thanks a lot :)
Great tutorial and show/tell! thank you!
Thank you so much! This was really helpful.
What a great and helpful video. Clear and on point. this has saved me hours....Thank you Sally.
Thanks for the feedback!
Thank you. this helped so much. I finally got it to work.
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. 🙂
Very useful, solved a difficult problem I was having!
Thanks a lot! like many others said below, after a long time I found your video which solved the issue I was having.
Brilliant... Thank you.. very easy to follow and bang on.. Thank you
I had watched so many videos but your video is Easy to understand and is very very helpful for me.. thanks a lot !!
Thank you! This was a very helpful tutorial.
Thanks a million. May God bless you always. Love from Malaysia
Thank you for this information, you have no idea how much it was needed today :)
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.
Awesome. ..been looking for this... thank you!
YOU ARE A LIFESAVER!!! THIS WAS AMAZING!
Thank you...Very much, finally what i was looking for : )
THANK YOU! THIS IS EXACTLY WHAT I NEEDED!!!!!!
Its a great video...So useful. Thank you again Sally, keep it up...
THANK YOU SOOO MUCH!VERY EASY TO FOLLOW TUTORIAL :)
I thank you !!!This was so helpful
I should really thank you for solving a huge issue :) Thanks for this very good video !!
Man, I love you, I always wanted to do this. This will save me tons of time. GRACIAS
Very useful - Thank you Ali
Wow, this is perfect for what I needed.
Time saving tips👌🏼
THANK YOUUUU OMG THIS IS WHAT IVE BEEN LOOKING FOR
Many thanks for sharing. Much appreciated.
Thank you, it is very helpful and very clear instructions,
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!
So is the Match function better than VlookUp? Im trying to understand the differences.
@@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).
@@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.
Amazing help. Thank you !!
Excellent and remarkable learning video, thank you for your magnificent efforts.. Fantastic explanation.
Awsome, Thank You this is a great video!!!!!!!!
Thanks so much, Sally! This was really helpful :)
Thanks, really looked for this one, many thanks,
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! : )
Awesome! Many thanks for this.
u have no idea how much this helped me. thanks a lot :)
Thank you so much! you are great! Bless you.
You saved my ass at my job...
Nicely described. Thanks
Awesome tutorial, thanks
Sally... Thank you so much.. really saved my mental stability :D :D :D
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.
Extremely awesome
I love the way u explain n help ... Thumbs up n subscribed
You are a lifesaver. Thanks so much for this
Glad it was helpful to you!
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.
Awesome & easy to get
This made the anxiety bubble in my head deflate. Thank you
youre amazing thank you for the content.
really you saved my day! thanks alot
Thanks for the help.
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.
This was helpful Thank you :)
Great presentation
Thanks, it was helpful
I like how you teach :)
Thank you for your help
Great Video!!
THANK YOU SO MUCH!!!!!!
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.
You are my hero!!!
Great tutorial Sally Ulianich
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.
Thanks for this tutorial ...i need more guide. I want that not only this formula and list work for only one customer but also need for other when i select other account on bottom cell ..as i have to made list in bottom all cell and select other account and their respective details ...how i can get this ..
Hi,, Sally, your videos are really nice and helpful. here I need to know that how to create a dropdown list which can display relevant data of that item available in other columns too.
thank god, it helps me alot