Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2022/10/Auto-Populate-Cells-Based-on-Value-in-Another-Cell.xlsx

In this video I demonstrate how to auto-populate cells based on the value selected in another cell's drop-down 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 drop-down of customer names
03:41 - Use VLOOKUP to auto-populate the address
06:38 - Hide zeros in the address block
------------------------