This video shows how to use the INDIRECT function in excel to: Use string values in cells to specify the reference in a formula Use string values in cells to The INDIRECT function in Excel returns the reference specified by a text string. In this tutorial, you learn how to use the function "INDIRECT". In short, INDIRECT returns a reference specified by a text string. This reference could be a cell or range of cells. Use the INDIRECT function in Excel when you want to change the reference to a cell within a formula without changing the formula itself. ExcelINDIRECTtutorial explains the function's syntax, basic uses and provides a number of formula examples that demonstrate how to use INDIRECT in Excel. Indirect function in Excel with Examples Excel Formulas Download this Example Excel file Here: The ExcelINDIRECT Function returns a reference to a range. The INDIRECT function does not evaluate logical tests or conditions. Free ExcelTutorial. In this tutorial, learn how to use ExcelINDIRECT Function. INDIRECT function returns the reference specified by the text string. It is a volatile function. Returns a reference to a range. The referenced range can be a cell, a range of cells, or a named range. The INDIRECT function mystifies lots of Excel users and one that does not get that much fan fare, but I am about to change that for you! To be totally honest, I wasn’t a big user of the Use Excel INDIRECT to dynamically refer to worksheets Sometimes you want to make a reference to certain worksheets dynamically using the Excel indirect function. For example if you have data in the same format split over multiple worksheets and you want to select data from different sheets dynamically.