Published On Nov 4, 2022
Download the featured file here: https://www.bluepecantraining.com/wp-...
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
------------------------
show more