Download the featured file here: https://www.bluepecantraining.com/wp...

In this video I demonstrate how to autopopulate cells based on the value selected in another cell's dropdown list.

Table of Contents:

00:00 Introduction
00:31 House your data in an Excel table
01:27 Define a name for the customer column
02:38 Create the dropdown of customer names
03:41 Use VLOOKUP to autopopulate the address
06:38 Hide zeros in the address block