S
scott.siegler
Hello,
I am wondering if it is possible with these three functions to perform the task I am looking to do.
Suppose in cell $A$1 is the string value "$B$10"
In cell B10 is the value 5 and in cell C10 is the value 6.
I can use the indirect function such as indirect(A1) to retrieve the value 5
Is there any way to get the value in C10 by adding a row to the value "$B$10" in cell A1?
I hope this makes sense.
Any help would be greatly appreciated.
Scott
I am wondering if it is possible with these three functions to perform the task I am looking to do.
Suppose in cell $A$1 is the string value "$B$10"
In cell B10 is the value 5 and in cell C10 is the value 6.
I can use the indirect function such as indirect(A1) to retrieve the value 5
Is there any way to get the value in C10 by adding a row to the value "$B$10" in cell A1?
I hope this makes sense.
Any help would be greatly appreciated.
Scott