Forum Discussion
Excel formula to get sheet name from a cell
I am trying to use a formula to reference a worksheet by getting the sheet name from a cell as shown below =IF(A34="","",MAX(Client10!C$3:C$33)) I have about 50 sheets and want to sect the sheet de...
You can get sheet names from one sheet to another with an easy formula...
on sheet1 have a formula in cell a1 that includes the sheet name reference: =Sheet1!B1
=TEXTBEFORE(TEXTAFTER(FORMULATEXT(sheet1!a1), "="), "!")