+ Reply to Thread
Results 1 to 2 of 2

Formula with data from other files

  1. #1
    Registered User
    Join Date
    04-03-2012
    Location
    Israel
    MS-Off Ver
    Excel 2007
    Posts
    3

    Formula with data from other files

    Hi,

    I can't upload my original file, but I added a file with an example for the next quastion:

    I have an excel file that need to get alot of data from other files.
    As you can see in the example file, every cell in my table should get a value from another file.
    There is a columne in the right with the names of the files that the data should get from.
    I want to drag the formula in the cells with the current value of #REF to all the other cells in the table, but I need that the name of the file will update by name that's written in right column.

    In the other files I always copy the cells from the same place.
    I have already tried formulas like this one: =INDIRECT("["&G2&".xlsx]Work!"&"E29"), but the problem is that E29 do not update when I drag the formula.
    I also tried this one, but the formula do not recognize the inner INDIRECT:
    =INDIRECT("["&G2&".xlsx]Work!"&INDIRECT(E29))

    What can I do???

    Example4.xlsx

  2. #2
    Valued Forum Contributor
    Join Date
    03-16-2012
    Location
    Aarhus, Denmark
    MS-Off Ver
    Excel 2007
    Posts
    992

    Re: Formula with data from other files

    You could make a helper column containg the cell references, E29, E30 etc., and then refer to that in your first formula instead of "E29".
    Last edited by Søren Larsen; 04-17-2012 at 09:36 AM.
    Sincerely
    S?ren Larsen

    "Give a man a fish, and you'll feed him for a day. Give a man a fishing rod, and he'll steal your yacht!"

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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