Top "Excel-indirect" questions

Returns the reference specified by a text string.

Dynamic chart range using INDIRECT: That function is not valid (despite range highlighted)

I'm trying to create a chart with a range built dynamically using the INDIRECT function. Excel does recognize the range …

excel dynamic range excel-formula excel-indirect
Returning cell values from other sheets by referencing sheet names from a list

I have a spreadsheet with approx twenty different sheets named by stock ticker. Because these are templates, the information in …

excel excel-formula formula worksheet-function excel-indirect
Adding previous cell and current cell functions

I like to have an Excel Function for: Previous cell + Current Cell = Current cell to do this function for the …

excel excel-formula sum worksheet-function excel-indirect
Automatically increment sheet reference when dragging formula

I have a formula with the following syntax: =SheetName!E10 and need some way to drag the formula and change …

excel excel-formula worksheet-function excel-indirect
How to code Excel VBA equivalent of INDIRECT function?

I have many uses of the INDIRECT function in my workbook, and it is causing performance issues. I need to …

vba excel excel-indirect
INDIRECT with column reference and row reference in different cells

So I have two cells, both referring to another sheet. One cell has the row of the other sheet and …

excel excel-formula worksheet-function excel-indirect
Convert Literal Text to Formula

Using MS Excel 2010: I used the CONCATENATE formula to create a text string that looks like a formula and need …

excel text excel-formula excel-indirect
Alternative to INDIRECT

I'm using the INDIRECT function to fetch data from another table sheet. The direct way would be "sheetname!A5". I …

excel performance excel-indirect