Mar 23 2022 05:47 AM
Hi,
I need to return a value from a specific cell on a different sheet. I have found that I need to use the INDIRECT formula as I need to return these values from several sheets and don't want to change the sheet name every time.
However, I am not sure what formula I can use to return the value of this cell. I have tried using INDEX but keep getting the #REF error.
INDIRECT("Week " & ROW(A101) & "!E$12")
I have added here the INDIRECT part of the formula, I just need to know how I can return the value in the cell.
Mar 23 2022 05:50 AM
SolutionSince the name of the worksheet contains a space, you must enclose it in single quotes:
=INDIRECT("'Week " & ROW(A101) & "'!E12")
This will return the value of cell E12 on the sheet named Week 101
Mar 23 2022 06:03 AM
Mar 23 2022 06:28 AM
That means that there is no worksheet named Week 101
Mar 23 2022 06:35 AM
Mar 23 2022 05:50 AM
SolutionSince the name of the worksheet contains a space, you must enclose it in single quotes:
=INDIRECT("'Week " & ROW(A101) & "'!E12")
This will return the value of cell E12 on the sheet named Week 101