Indirect
How To Use Excel Indirect Function Examples
The excel INDIRECT function can convert a text string to a valid reference. For example, INDIRECT(“A1”) will return a reference to cell A1, and INDIRECT(“Scores”) will return a reference to a named range ( suppose Scores is the range object name ). This article will tell you how to use the excel INDIRECT function with …