Forum Discussion
How do I reference a cell in another sheet using a value from the active sheet
I want to reference cells in another sheet, I know how to reference them directly but I need to reference them from a value that points to the cell that is in the active sheet. I know this doesn't ...
Hi Nick_Booth
Look at the https://support.microsoft.com/en-us/office/indirect-function-474b3a3a-8a26-4f44-b491-92b6306fa261 function, ex.: =INDIRECT("Sheet1!" & C3)
I think it must be as my sheets are named. If change them back to sheet1 it works.
It's because I have titles with spaces for the sheet names.
I need to change the way it references the sheet.
Thanks
It's because I have titles with spaces for the sheet names.
I need to change the way it references the sheet.
Thanks
If you have space in your sheet names you must add simple quotes around the sheet name, as below:
=INDIRECT("'My Other Sheet'!" & C3)