Hi, I will greatly appreciate your help on this question as I've hit a mental block
My question is about the correct syntax to use for my problem. Say, I have a formula in cell A1 on Sheet1
=Sheet2!N2+10
Say, I also have a cell on the same tab, B1, where letter N is generated by another formula. I need to know either:
1) What is the syntax to substitute column letter N in the formula above with a reference to cell B1 on Sheet1
or
2) What is the syntax that I can use to substitute the column letter N in the formula above with the formula below in cell B1?
The letter N is generated by a formula =SUBSTITUTE(SUBSTITUTE(ADDRESS(10,MATCH($C$1,'Sheet2'!$A$8:$Z$8,0)),"$",""),10,"")
Thank you very much for your time!
My question is about the correct syntax to use for my problem. Say, I have a formula in cell A1 on Sheet1
=Sheet2!N2+10
Say, I also have a cell on the same tab, B1, where letter N is generated by another formula. I need to know either:
1) What is the syntax to substitute column letter N in the formula above with a reference to cell B1 on Sheet1
or
2) What is the syntax that I can use to substitute the column letter N in the formula above with the formula below in cell B1?
The letter N is generated by a formula =SUBSTITUTE(SUBSTITUTE(ADDRESS(10,MATCH($C$1,'Sheet2'!$A$8:$Z$8,0)),"$",""),10,"")
Thank you very much for your time!