HunterN
Active Member
- Joined
- Mar 19, 2002
- Messages
- 479
Hi!
I have several workbooks. One is the master workbook that will hold data from several seperate workbooks. I want to use the VLOOKUP function as I move down the rows in the master workbook, the thing is, that means that the table-array (or the workbook that I am searching) will change for each row I go to. I am trying to find an example of how to make a dynamic variable for the table-array that will allow me to change this variable for each row.
This is what I am thinking:
VLOOKUP($C$3, _
'C:My Project["0251.xls"]Sheet1! $A$3:$D$52,2,false)
The "0251.xls" will change for each row I read
Have any suggestions? Thanks
This message was edited by HunterN on 2002-04-23 05:57
I have several workbooks. One is the master workbook that will hold data from several seperate workbooks. I want to use the VLOOKUP function as I move down the rows in the master workbook, the thing is, that means that the table-array (or the workbook that I am searching) will change for each row I go to. I am trying to find an example of how to make a dynamic variable for the table-array that will allow me to change this variable for each row.
This is what I am thinking:
VLOOKUP($C$3, _
'C:My Project["0251.xls"]Sheet1! $A$3:$D$52,2,false)
The "0251.xls" will change for each row I read
Have any suggestions? Thanks
This message was edited by HunterN on 2002-04-23 05:57