+ Reply to Thread
Results 1 to 2 of 2

Dynamic VLookUp

  1. #1
    Registered User
    Join Date
    12-17-2008
    Location
    Singapore
    MS-Off Ver
    2002
    Posts
    71

    Dynamic VLookUp

    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

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678
    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.
    No, you can't.
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1