Maybe I misread your question.

maybe you want to use =indirect().

Something like:
=indirect("'" & x88 & "'!" & x99)
where x88 contains the sheet name (sheet4)
and x99 contains the address of the cell (A2)



sarah - northampton wrote:

I am trying to concatenate cells and have the result execute within a
formula. I am ending up with: =sheet4!A2 instead of the value that is
contained in that location.

--

Dave Peterson