Indirect Formula

L

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Indirect 1
Using range with INDIRECT and ROW() 4
Excel sum if and closed workbooks 2
What does "--" (2 minus signs) do in a formula 1
What is "--" in Excel Formula (SUMPRODUCT) 2
Indirect function in Index/Match Array 5
Sumproduct - Indirect - NOT WORKING????? Please help 4
Formula Simplifications Using Nested If, Indirect & Address Functi 3

Top