Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2022/01/Drop-Down-Get-Data-From-Another-Worksheet.xlsx

In this video I demonstrate how to extract data from a specific worksheet based on that worksheet name being selected in a drop-down list. To achieve this you need to understand the syntax used when referencing cells on another worksheet. You also need to know about the INDIRECT function.

Table of Contents:

00:00 - Introduction
00:20 - How to create a drop-down list of worksheet names
01:22 - Understanding the syntax for referring to cells on another worksheet
01:49 - Understanding the INDIRECT function
02:51 - How to refer to worksheet names that contain spaces
04:48 - Perform a VLOOKUP across worksheets
08:11 - Use the COLUMN function to automate the col_index_num
------------------------