Getting Cell Value from the Concatenate formula

[Johnny]

I built a concatenate formula that returns the following result: =Jul!
$D27

I am looking for the cell contents of Sheet: July Column D Row 27.
I tried to use offset, but I am stumped. Can I add something to the
front of the concatenate to not only build the reference to the cell,
but also return the value instead of the =Jul!$D27 ?

Thanks
John

 

[Dave Peterson]

=indirect(yourformulahere)

Don't include the equal sign in your formula. And match the name correctly (Jul
or July???).

Depending on the name of the worksheet, you may need to have a string that looks
like:

'Sheet 99'!d27

=indirect("'" & a1 & "'!d27")
if A1 contained the sheet name.

If you don't need the apostrophes, it won't hurt.