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...
Try this:
=IF(A34=“”,””,
MAX(INDIRECT(“Client”&A34&
“!C3:C33”)))
=IF(A34=“”,””,
MAX(INDIRECT(“Client”&A34&
“!C3:C33”)))
- Many thanks for this. It has worked a treat.
- You’re welcome.
