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

The Excel INDIRECT function is a Lookup and Reference function, and its purpose is to return the reference specified by a text string. You can use the INDIRECT function when you want to change the ...