make a vlookup using a variable path
 

Hello,
I have 10 files which are identicals. In han other workbook, I use vlookup
from any of the 10 files depending of the records. In this workbook, I have a
column which contains the name of each files from which I would like to make
the vlookup. So, I would like to make a vlookup using a variable path name.
What is the function to convert a variable path name in text to a real path
name in Vlookup ?
VLOOKUP($A2;concatenate("c:\";B2;"Merge!$B$2:$AL$3 00");2;0)
B2 = variable file name
Thanks,
--
Alex St-Pierre

=VLOOKUP($A2;INDIRECT("c:\"&B2&"Merge!$B$2:$AL$300 ");2;0)


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Alex St-Pierre" wrote in message
...
Hello,
I have 10 files which are identicals. In han other workbook, I use vlookup
from any of the 10 files depending of the records. In this workbook, I
have a
column which contains the name of each files from which I would like to
make
the vlookup. So, I would like to make a vlookup using a variable path
name.
What is the function to convert a variable path name in text to a real
path
name in Vlookup ?
VLOOKUP($A2;concatenate("c:\";B2;"Merge!$B$2:$AL$3 00");2;0)
B2 = variable file name
Thanks,
--
Alex St-Pierre