Referencing A cell location within a cell

[soccerstarmikew]

I have created a model that updates each day and pulls quotes from a certain number of days. Depending on what number of days i put in, an indirect function will generate a location to end the data pull. For instance if i put 10 days it will generate A11 in a cell. I would then pull A1:A11. I want to put this value A11 into a cell that pulls the correlation which is on another page. It would look like Correl(Sheet1!A1:Sheet1!& A11,Sheet1!B1:Sheet1!& B11) I want the A11 in that formula to be found int the cell that generates the value A11. How can i do this? Thanks for the help.

 

[Oaktree]

Welcome to the board.

For instance if i put 10 days it will generate A11 in a cell

You probably don't need to go there. Since your CORREL formula would need to adjust B11 as well, consider using something like this:

=CORREL(OFFSET(Sheet1!A1,,,E1+1),OFFSET(Sheet1!B1,,,E1+1))

Where E1 is your days input (10 in your example)