To create dynamic dropdown lists, you typically need to use named ranges and the INDIRECT function in Excel. The function references a range of cells that change based on what you selected in the ...

You can use information you already have in your spreadsheet to create a reference. The reference created using the INDIRECT function will stay the same, even if your sheet's structure changes.