DorianGrim
New Member
- Joined
- Oct 10, 2011
- Messages
- 13
Hi all,
I am dealing with a huge amount of data on google and forums, but can't seem to place it all together.
1. I need concatenation for this, since from what I read INDIRECT() does can't open closed excel files.
2. I can't use MOREFUNC | Ashish Mathur's Blog (morefunc), cause it's on the network, and I can't tell 100 people to install the add-in.
What I have is:
The evaluation of the formula shows me the variable names ok, so the concatenation works, but I get #VALUE! error...
I am guessing my opening " and closing ", make the whole thing a string. But I really don't know.
I am open to other suggestions, but given the facts.
Please help.
Thanks in advance,
Dorian
I am dealing with a huge amount of data on google and forums, but can't seem to place it all together.
1. I need concatenation for this, since from what I read INDIRECT() does can't open closed excel files.
2. I can't use MOREFUNC | Ashish Mathur's Blog (morefunc), cause it's on the network, and I can't tell 100 people to install the add-in.
What I have is:
Code:
[FONT=lucida console]=HLOOKUP(A1,"'\\sftest\me\!reports\f\" & TEXT(A1, " yyyy ") & "\[EC" & TEXT(A1, "mmm ") & TEXT(A1, "yyyy ")& ".xls]PPD'!$B$1:$AF$30",30)[/FONT]The evaluation of the formula shows me the variable names ok, so the concatenation works, but I get #VALUE! error...
I am guessing my opening " and closing ", make the whole thing a string. But I really don't know.
I am open to other suggestions, but given the facts.
Please help.
Thanks in advance,
Dorian
Last edited:
