The real power of dependent drop-down lists comes from using the INDIRECT function in Excel. The INDIRECT function allows you to create a reference to a cell or range based on a text string.

Discover why Excel's INDIRECT function is outdated and learn smarter alternatives like Power Query, FILTER, and LAMBDA for ...

The reference created using the INDIRECT function will stay the same, even if your sheet's structure changes. By default, references in Excel use the A1 reference style, which means that it refers to ...

Drop-down lists in Excel let you create a list of valid choices that you can select for a given field. ... Enter the INDIRECT function as a relative formula, then copy. 11.

Learn how to use the INDIRECT function in Excel in easy steps. Skip to primary navigation; ... Then select INDIRECT from the drop-down menu. A Function Arguments dialog box will open.