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

cell a16 had the worksheet name typed into it.

--
Don Guillett
SalesAid Software

"lmullenjr" wrote
in message ...

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

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