Hi all,
I recently posted here about doing a LOOKUP combined with a INDIRECT to look on multiple colunms (solved) but now i need to perform a similar task acros more than one file.
A1 B1 C1
1900 S:\Folder\Takeway\[Food FY15 WK1.xlsx]WK1'!$C$52 #REF!
A1 = Desired cell figure (using ='S:\Folder\Takeaway\[Food FY15 WK1.xlsx]WK1'!$C$52)
But when i use C2 to INDIRECT search B1 for the exact same text it returns #REF!
What am i doing wrong?
Last edited by zendetta2608; 10-07-2015 at 07:22 AM.
AFAIK, the file needs to be open for INDIRECT to function, not closed.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Thanks TMS, ive tried and it still isnt working.
C1: =INDIRECT(B1)
B1: '[Food FY15 WK1.xlsx]WK1'!$C$52
For a similar project I used INDIRECT.EXT and had to install an add in to excel on the machines that needed to use the file
Ive got it to work with the external file open.
C1: =INDIRECT(B1)
B1: ="'[Food FY15 WK1.xlsx]WK1'!$C$52"
Im guessing its just a matter of getting it to format. but i would love to be able to use closed file . Ill look into this add in, thanks for that nigelog
Ah, yes, I think the first single quote mark (') will just cause the content of the cell to be treated as text, thus getting lost.
I think the Add-in is going to be your best bet.
Regards, TMS
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks