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 (http://www.screencast-o-matic.com)

Thanks for tuning in!

• #howto_style
• #sally_u_tutorials
• #sally_ulianich
• #tutorial
• #excel