I am trying to reference an external workbook/sheet/cell but need to use (I think!) INDIRECT() to pull in the proper cell value.
Here is the formula that works using direct cell reference:
That references the correct file, sheet, and cell and returns the contents of cell N2 properly.
However, the sheet names, in text form, vary in column “A”, so I tried to use INDIRECT() for the sheet name:
This does not work. I have tried different ways to format using INDIRECT, but get various errors depending on how I use the #, $, ", and ’ formatting characters. In this example I get:
I believe it is just a formatting issue, but perhaps something more?