Help using INDIRECT with formula string

Firstly, happy new year!

I'm trying to convert a string of text joined by CONCATENATE to result in a formula which references a cell on another workbook (on our server but in the same location as the master workbook).

My testing of the string and formula works when I copy/paste-special into a new cell and return the correct value of the workbook.

My problem occurs when I try to resolve the string using INDIRECT. I've had a good internet and forum search with no luck. I return the #REF! error, perhaps my string isn't a valid reference?

Below are screen dumps of the formula and it's result.

A side note, I've read that the other workbook needs to be open. I've tried it open and closed on the tests (copy/paste-special) and it works both ways!

Thanks

Mike

Hi,

I'm not clear what you're asking. There's no reference to the INDIRECT() function in your examples.

Incidentally when posting examples, would you upload actual workbooks, or at least the relevant sections of them, as recommended in the forum rules. Pictures of formulae don't really help, and people are less inclined to assist if they find themselves having to create your formulae from scratch in order to test.

Rgds

Thanks Andy for the quick reply. Removing the = worked.

Appologies for not including the text or actual workbooks Richard, I'll keep to the guidlines in future.

I've read a few articles about work-arounds to reference cells from a closed workbook.

Can anyone advise a good mothod or point me to thread?

Thanks again.

Mike

Just thought I'd post the solution I found.

Using the INDIRECT.EXT from the MoreFunc add-in solved my problem.

Thanks

Mike