I was trying to do a vlookup on several external files, using the following:
=VLOOKUP(A1,[Book2.xls]Sheet1!$A:$B,2,0)
However what it i have 3 files ,name "Data2","Data3",Data4".
Can I do a vlookup in all the file name containing "Data" , without specifying
a vlookup individually on each files,this is because the number of files with the files names could be different at times.
I attached 4 files, Book 1 is the worksheet i working on. Data2, Data3, Data4 contain all the information i wan to do a vlookup in, and return the cash in the files contain the "Data".
What If I wan to do a vlookup on Mary instead ?
Book1.xls
Data2.xls
Data3.xls
Data4.xls
Bookmarks