Excel INDIRECT Function Explained with Examples + Video

This is not specific to the INDIRECT function; the same limitation is true in all formulas. If the sheet names are changed, the formula will automatically recalculate. The formula in C5 concatenates the text in B5 to the string “!A1” and returns the result to INDIRECT. The text entered in column E represents different ranges. […]