Getting Cell Value from the Concatenate formula

  • Thread starter Thread starter Johnny
  • Start date Start date
J

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
 
=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.
 
Back
Top