+ Reply to Thread
Results 1 to 2 of 2

Lookup in Multiple Workbooks and Return Value

  1. #1
    Registered User
    Join Date
    07-13-2009
    Location
    North Hollywood
    MS-Off Ver
    Excel 2007
    Posts
    5

    Lookup in Multiple Workbooks and Return Value

    Hello everyone!

    I have the following scenario:
    • One main workbook (lets call it A)
    • Five additional workbooks (lets call them 1,2,3,4,& 5)

    A has the following header:
    Associate Rev 1 Coaching 1 Rev 2 Coaching 2

    1,2,3,4,& 5 have the following header:
    Associate Coaching 1 Coaching 2 Rev 1 Rev 2


    What I need:
    From A,search 1,2,3,4,& 5 for the same Associate and place Rev 1, Rev 2, Coaching 1, and Coaching 2 in its respective places in A. The associate names can move from one workbook to another during any given time which is why I am thinking a simple "=[1.xslx]Sheet1!" will not work. I have tried a number of VLOOKUP combination's with no luck.
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    01-20-2012
    Location
    London
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Lookup in Multiple Workbooks and Return Value

    I have a very similar problem to above, I want to collect data from multiple excel workbooks into one summary worksheet - can anybody help?

    I need a function that allows me to:

    Search for relevant workbook by file name
    Lookup an Account code within that worksheet and provide the cost attributed to that account code.

    Any help is greatly appreciated.

    Thanks,
    Ben

+ 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