For example, you can change a reference to a cell within a formula without changing the formula itself. The INDIRECT function is a great way to create links between worksheets within a workbook.

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