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")
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!