S
Sungibungi
Hello users.
I'm trying to figure out a way to dynamically reference file names that have
different months. I am trying to do the following:
There is a master file and many slave files (organized into months).
Master.xls wants to vlookup data corresponding to date from corresponding
month file.
Example:
A B
1/1/2009 --> Vlookup from "Jan 09.xls" column one to find 1/1/2009 and
return Column B
Inside Master.xls file, I extracted each file extension ("Jan 09", "Dec 10",
etc) in column Z to reference.
So then I used this formular to start the dynamic referencing:
=vlookup($A1,INDIRECT("'[C:\...\"&$Z1&".xls]Sheet1'!A:B"),2,0)
This results in a #REF but it seems the
INDIRECT("'[C:\...\"&$Z1&".xls]Sheet1'!A:B") segment of the formular should
work fine. I'm not sure. Am I missing something? Could someone help me out
here?
Many thanks in advance.
I'm trying to figure out a way to dynamically reference file names that have
different months. I am trying to do the following:
There is a master file and many slave files (organized into months).
Master.xls wants to vlookup data corresponding to date from corresponding
month file.
Example:
A B
1/1/2009 --> Vlookup from "Jan 09.xls" column one to find 1/1/2009 and
return Column B
Inside Master.xls file, I extracted each file extension ("Jan 09", "Dec 10",
etc) in column Z to reference.
So then I used this formular to start the dynamic referencing:
=vlookup($A1,INDIRECT("'[C:\...\"&$Z1&".xls]Sheet1'!A:B"),2,0)
This results in a #REF but it seems the
INDIRECT("'[C:\...\"&$Z1&".xls]Sheet1'!A:B") segment of the formular should
work fine. I'm not sure. Am I missing something? Could someone help me out
here?
Many thanks in advance.