Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP not returning results | Excel Worksheet Functions | |||
any way to make vlookup case sensitive? | Excel Worksheet Functions | |||
vlookup data hidden within worksheet | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
make hidden window or workbook visible without specify the name | Excel Worksheet Functions |