+ Reply to Thread
Results 1 to 4 of 4

Dynamic type lookup

  1. #1
    Registered User
    Join Date
    03-05-2012
    Location
    Helsinki, Finland
    MS-Off Ver
    Excel 2010
    Posts
    10

    Dynamic type lookup

    Hi,

    I'm making a report that will pull information from another report. I'm doing this to automate month end reports and I'd like the report I'm making, to require little input except to hit F9.

    In order to do this, I want to populate the Amount, Price, Market Value, and percentage columns with the respective values in the respective files. I also dont want to update each and every cell value so that it references the new month end. So, I don't know if this is the most efficient way, but I thought I could use a master file location and have each cell use that, plus the corresponding cell location in the correct file. Confusing...yeah.

    On the attached, what im after is G8 to first take the extension located in C3, plus the specific cell in the sheet of C3.

    Is there any easier way to do this? Im sure a macro could do that but i have no experience with that so can't utilize that.

    Thanks in advance
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Dynamic type lookup

    A macro could do it but the indirect function only works within the same workbook.

    http://www.excelforum.com/excel-gene...nal-files.html
    Please ensure you mark your thread as Solved once it is. Click here to see how.
    If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.

  3. #3
    Registered User
    Join Date
    03-05-2012
    Location
    Helsinki, Finland
    MS-Off Ver
    Excel 2010
    Posts
    10

    Re: Dynamic type lookup

    Thanks Mike - Sorry about not finding it in the search function. Honestly didn't have a clue what to search for.

    Doesn't look like there is an easy way to do it this way. I'll think of something else. Can't risk downloading additional software as it's probably not approved by my admin.

  4. #4
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,048

    Re: Dynamic type lookup

    No worries, your questions peaked my interest as I was wondering the same as well.

    What you COULD do, is link a table from another workbook, then use indirect to point the cells to the linked table within that workbook.

    It is sloppy but depending on how complicated the files are it could work.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Is this possible - type of Vlookup dynamic range
    By bottera in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 12-04-2012, 10:49 AM
  2. automatically fill from dynamic list as I type
    By 2funny4words in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-10-2009, 11:51 PM
  3. Some type of LOOKUP
    By sick stigma in forum Excel General
    Replies: 1
    Last Post: 01-27-2009, 10:30 PM
  4. Can this be done? Type of lookup
    By Kmagg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-02-2005, 06:17 PM
  5. Dynamic arrays and type mismatches
    By carg1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-01-2005, 03:13 PM

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