Linking two different workbooks with vlookup
 

I´m having a problem about linking a few workbooks to one, my idea initially
was that i can separate the reference, lets suppose my formula goes this way:

VLOOKUP($A1,'C:\INFO\MONTH\[REPORT MONTH.xls]Sheet3'!$B$4:$J$158,$A39,FALSE)

Now my idea is that if I have a several number of months saved in a folder
with the name of the month, then I can referentiate the month in a column,
lets say I could do something like this:

=Concatenate("'C:\INFO\","B5","\[REPORT","B5",".xls]Sheet3'!$B$4:$J$158")

Where the value of B5 is (January, February.... or anymonth) plz

BUT!!!!!!! This is not working so I would really appreatiate some help with
this cuz i think this will solve a lot of problems.

Linking two different workbooks with vlookup
 

VLOOKUP($A1,'C:\INFO\MONTH\[REPORT
MONTH.xls]Sheet3'!$B$4:$J$158,$A39,FALSE)

Now my idea is that if I have a several number of months saved in a
folder with the name of the month, then I can referentiate the month
in a column, lets say I could do something like this:

=Concatenate("'C:\INFO\","B5","\[REPORT","B5",".xls]Sheet3'!$B$4:$J$158
")

Where the value of B5 is (January, February.... or anymonth) plz

BUT!!!!!!! This is not working ...

Try removing the quotes from around B5 in the concatenation.

The formula needs to have the contents of the cell B5, not the two-
character string "B5".

Linking two different workbooks with vlookup
 

MMMM that doesn´t work (I wrote wrong the formula in the discussion board) I
think the formula can´t be entered that way but thanks for trying it....
probably the vlookup can´t work with concatenations that way, do you know
another possible way to work it out?

"MyVeryOwnSelf" wrote:

VLOOKUP($A1,'C:\INFO\MONTH\[REPORT
MONTH.xls]Sheet3'!$B$4:$J$158,$A39,FALSE)

Now my idea is that if I have a several number of months saved in a
folder with the name of the month, then I can referentiate the month
in a column, lets say I could do something like this:

=Concatenate("'C:\INFO\","B5","\[REPORT","B5",".xls]Sheet3'!$B$4:$J$158
")

Where the value of B5 is (January, February.... or anymonth) plz

BUT!!!!!!! This is not working ...

Try removing the quotes from around B5 in the concatenation.

The formula needs to have the contents of the cell B5, not the two-
character string "B5".

Linking two different workbooks with vlookup
 

I'm having a problem about linking a few workbooks to one, my idea
initially was that i can separate the reference, lets suppose my
formula goes this way:

VLOOKUP($A1,'C:\INFO\MONTH\[REPORT
MONTH.xls]Sheet3'!$B$4:$J$158,$A39,FALSE)

Now my idea is that if I have a several number of months saved in a
folder with the name of the month, then I can referentiate the month
in a column, lets say I could do something like this:

=Concatenate("'C:\INFO\","B5","\[REPORT","B5",".xls]Sheet3'!$B$4:$J$158
")

Where the value of B5 is (January, February.... or anymonth) plz

BUT!!!!!!! This is not working so I would really appreatiate some help
with this cuz i think this will solve a lot of problems.

Maybe this would be a start.
=VLOOKUP($A1,
INDIRECT("'C:\INFO\"&B5&"\[REPORT"&B5&".xls]Sheet3'!$B$4:$J$158"),
$A39,FALSE)

I haven't tried your example, but have used a similar approach within one
workbook.

(I have Excel 2003.)

Linking two different workbooks with vlookup
 

If you're still having trouble, Excel has a feature that might help.

In Excel 2003, select the cell with the troublesome formula and use:
Tools Formula auditing Evaluate formula
The resulting dialog box walks through the evaluation steps that Excel
uses. Each time you click "Evaluate" Excel does one more step. In this
case, if you click until the argument of INDIRECT(__) is one underlined
string, it'll show exactly the table_array being used for VLOOKUP(). That
should help adjust the table_array's fragments, if needed.