Forum Discussion
Solved
Returning a single cell value from a separate sheet
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...
Since 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
This is still returning the #REF! error
That means that there is no worksheet named Week 101
- Its working now thank you