Drop Down List Based on Table Data

zgadson

Board Regular
Joined
Jul 16, 2015
Messages
64
Office Version
  1. 365
  2. 2019
Platform
  1. Windows
My question is pretty simple, but I can't seem to find any information on how to achieve my goal - which is to create a drop down list based on data in a table.

My table list aisles and slots within the aisle (warehouse storage), so the 1st column is AISLE, 2nd column is SLOT. From here I need 2 drop down boxes, 1 to select the aisle (which I already have), and the 2nd drop down to list only the slots within that aisle).

My sheet is 30k+ lines long, so if I can avoid creating an actual list for each aisle it would save me hours of time, and assuredly lots of unnecessary processing power.
 

Some videos you may like

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Watch MrExcel Video

Forum statistics

Threads
1,114,019
Messages
5,545,531
Members
410,689
Latest member
ConfuzzledThomas
Top