I want to create a formula in Name Manager using the reference of other sheet. I have two sheet A1 and A2; in sheet A2 i have sample data. Using this sample data i want to create a list which will be used in sheet A1 depending on other Drop-down value. I want to create a name for formula:
=A2!$C$10:$C$12
But in this formula i want to change column number 10 and 12 with another cell (in same sheet A2) values.
Like: =CELL("contents",E6)
.
I have tried:
=A2!$C$CELL("contents",E6):$C$CELL("contents",F6)
But its not working.
How can i change the column numbers with other cell values?