Sunday, March 5, 2017

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

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! Check out my website at http://bit.ly/1TKzTtT Video recorded using Screencast-O-Matic (http://bit.ly/1XplPoI) Thanks for tuning in!
Tutorial: How to Auto-Populate Fields in Excel Using a Drop-Down and VLookup

No comments:

Post a Comment