Anyone know why when using indirect I cannot reference a worksheet with a dash or space in it's name? For example, here is my function:

=INDIRECT(P2&"!s34")



In P2 I've entered OCT-HDD to reference worksheet OCT-HDD. When I do this, the result is the dreaded #REF!. I get the same result if I reference a sheet with a space in its name (OCT HDD).

If I rename the sheet OCT and enter OCT in my reference cell, it works. So I COULD rename all my worksheets. However, I have several other workbooks that reference back to these worksheets and I fear I will introduce other errors if I rename worksheets to which I have existing references.

Anyone had this problem before? Anyone know how to fix this?

Thanks for your help and replies.

Try

=INDIRECT("'"&P2&"'!s34")