Hiya
So far VBA Express helped me dozens of times, hope you experts can help me again with this.
I have been struggling with this for a while now and not sure if it is possible but i give it a shot ^^
At the moment i have this working formula:
=IF(ISNA(VLOOKUP($A$6;[D213.xls]OrderMP3!$C$17:$I$9999;2;FALSE)=TRUE);"";(VLOOKUP($A$6;[D213.xls]OrderMP3!$C$17:$I$9999;2;FALSE)))
While I would like to have this formula (not working atm):
=IF(ISNA(VLOOKUP($A$6;INDIRECT("'C:\Documents and Settings\datasheet\[D213.xls]OrderMP3!'$C$17:$I$9999");2;FALSE)=TRUE);"";(VLOOKUP($A$6;INDIRECT("'C:\Doc uments and Settings\datasheet\[D213.xls]OrderMP3!'$C$17:$I$9999");2;FALSE)))
But with the D213.xls replaced by a cell ref. I would like to make a formula similar like this:
=IF(ISNA(VLOOKUP($A$6;INDIRECT("'C:\Documents and Settings\datasheet\[C2.xls]OrderMP3!'$C$17:$I$9999");2;FALSE)=TRUE);"";(VLOOKUP($A$6;INDIRECT("'C:\Doc uments and Settings\datasheet\[C2.xls]OrderMP3!'$C$17:$I$9999");2;FALSE)))
Where C2 contains the "D213" text.
This way i can make the sheet standard, only the C2 needs a new number and the cells with the formula dont have to be changed.
My other workbook D213.xls is open so indirect function should work?
Can this be done with a formula or does it need VBA? *keeps fingers crossed a formula does the job* easiest to implement into the existing sheet ...
Thx loads in advance!
Best regards,
Eville