Indirect Formula

[lmullenjr]

I have inherited a spreadsheet from a former employee and cannot figure out the Indirect formula he used. Can someone explain the following:


INDIRECT("'"&$A16&"'!G15")

Thanks

Larry

[Don Guillett]

cell a16 had the worksheet name typed into it.

--
Don Guillett
SalesAid Software
dguillett1@austin.rr.com
"lmullenjr" <lmullenjr.27lhqm_1147270203.0898@excelforum-nospam.com> wrote
in message news:lmullenjr.27lhqm_1147270203.0898@excelforum-nospam.com...
>
> I have inherited a spreadsheet from a former employee and cannot figure
> out the Indirect formula he used. Can someone explain the following:
>
>
> INDIRECT("'"&$A16&"'!G15")
>
> Thanks
>
> Larry
>
>
> --
> lmullenjr
> ------------------------------------------------------------------------
> lmullenjr's Profile:
> http://www.excelforum.com/member.php...o&userid=33132
> View this thread: http://www.excelforum.com/showthread...hreadid=540658
>

[Miguel Zapico]

The formula looks for the value in the cell A16 of the current worksheet,
that will probably contain a worksheet name, and shows the value of cell G15
of that referenced worksheet.
There is no dollar sign in front of the the row number, so that reference
will change if the formula is copied in a different row.

Hope this helps,
Miguel.

"lmullenjr" wrote:

>
> I have inherited a spreadsheet from a former employee and cannot figure
> out the Indirect formula he used. Can someone explain the following:
>
>
> INDIRECT("'"&$A16&"'!G15")
>
> Thanks
>
> Larry
>
>
> --
> lmullenjr
> ------------------------------------------------------------------------
> lmullenjr's Profile: http://www.excelforum.com/member.php...o&userid=33132
> View this thread: http://www.excelforum.com/showthread...hreadid=540658
>
>