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.

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 ...