Easily reference cell data using Named Ranges and the INDIRECT function in Excel
The INDIRECT function can be especially useful in reference-heavy workloads. Depending on the data entered, it can return a number of different things, including, but not limited to, cell contents, references, and cell ranges. Combine it with other functions to make even more powerful calculations!