software

I have inherited a spreadsheet from a former employee and cannot figure
out the Indirect formula he used. Can someone explain the following:INDIRECT(quot;'quot;amp;$A16amp;quot;'!G15quot;)

Thanks

Larry--
lmullenjr
------------------------------------------------------------------------
lmullenjr's Profile: www.excelforum.com/member.php...oamp;userid=33132
View this thread: www.excelforum.com/showthread...hreadid=540658cell a16 had the worksheet name typed into it.

--
Don Guillett
SalesAid Software

quot;lmullenjrquot; gt; wrote
in message ...
gt;
gt; I have inherited a spreadsheet from a former employee and cannot figure
gt; out the Indirect formula he used. Can someone explain the following:
gt;
gt;
gt; INDIRECT(quot;'quot;amp;$A16amp;quot;'!G15quot;)
gt;
gt; Thanks
gt;
gt; Larry
gt;
gt;
gt; --
gt; lmullenjr
gt; ------------------------------------------------------------------------
gt; lmullenjr's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33132
gt; View this thread: www.excelforum.com/showthread...hreadid=540658
gt;
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.

quot;lmullenjrquot; wrote:

gt;
gt; I have inherited a spreadsheet from a former employee and cannot figure
gt; out the Indirect formula he used. Can someone explain the following:
gt;
gt;
gt; INDIRECT(quot;'quot;amp;$A16amp;quot;'!G15quot;)
gt;
gt; Thanks
gt;
gt; Larry
gt;
gt;
gt; --
gt; lmullenjr
gt; ------------------------------------------------------------------------
gt; lmullenjr's Profile: www.excelforum.com/member.php...oamp;userid=33132
gt; View this thread: www.excelforum.com/showthread...hreadid=540658
gt;
gt;