You may be familiar with creating a drop-down list in Excel using the Data Validation feature. But here's how you could create a drop-down list that changes depending on what's in another cell.
Click the link below to download a copy of the file that I used in the video:
Dynamic Drop Down
.xlsx
Download XLSX • 10KB