Forum Discussion
Solved
Extracting a Sheet Name from Text Cell
I am writing a formula to reference a value on another sheet and running into an error I can't explain. The workbook has several dozen sheets, each describing the electrical loads on one of the b...
R for row and C for column are reserved. Somehow this has impact on sheet names - even when the sheet name has additional characters.
=INDIRECT(IF(ISNUMBER(FIND(",",[@Panel])),CONCAT("'",LEFT([@Panel],FIND(",",[@Panel])-1),"_",RIGHT([@Panel],1),"'"),{@Panel])&"!C24")
With a little more digging, I think I found the issue, but I still don't understand the problem. I tried referencing the cells manually. The "A" panel looks like this:
=A1_2!C24But the "C" panel looks like this:
='C1_2'!C24
For some reason, two of my two-section panel sheet names have single quotes around the names, and the other three don't. Why would that be, and how can I fix it?
R for row and C for column are reserved. Somehow this has impact on sheet names - even when the sheet name has additional characters.
=INDIRECT(IF(ISNUMBER(FIND(",",[@Panel])),CONCAT("'",LEFT([@Panel],FIND(",",[@Panel])-1),"_",RIGHT([@Panel],1),"'"),{@Panel])&"!C24")
- Gotcha... Yep, my other problem child is "R1, R2". Thank you!