+ Reply to Thread
Results 1 to 1 of 1

INDEX / MATCH Function to grab JPEG across 2 workbooks

  1. #1
    Registered User
    Join Date
    10-25-2017
    Location
    Texas, United States
    MS-Off Ver
    Excel 2016
    Posts
    18

    INDEX / MATCH Function to grab JPEG across 2 workbooks

    I was using the Index Match function to pull in JPEG images from a 2-column table contained in the same workbook on a separate sheet. This worked fine. The picture table is very large causing the total file to be 3.5 MB. I moved the picture table sheet to a new workbook and the master file shrunk down to 240 KB....awesome!. The link in the formula under Name Manager also changed itself to include the file path to the new picture file location. However now, the JPEGs are not appearing in the master file like they were before.

    Is there a different method I need to use to INDEX/MATCH and pull JPEGs across 2 workbooks? I would think the fix would be relatively easy seeing that the only change is across 2 workbooks instead of 2 sheets. Thanks in advance for the help!
    Last edited by EFD; 02-02-2018 at 12:34 PM.

+ 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. I am having problems using Index Match on 2 workbooks
    By masta_mick in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 06-12-2017, 02:28 AM
  2. Index and Match across two different workbooks
    By evans1 in forum Excel General
    Replies: 7
    Last Post: 01-25-2017, 03:53 PM
  3. Index/Match closed workbooks
    By kbkrueger in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-21-2015, 12:49 AM
  4. index or match two columns in different workbooks
    By shmemushi in forum Excel General
    Replies: 4
    Last Post: 05-07-2015, 02:30 PM
  5. Index Match across 2 workbooks?
    By Barking_Mad in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-12-2015, 07:44 AM
  6. Index and Match Two Workbooks
    By madaboutgolf in forum Excel General
    Replies: 0
    Last Post: 10-09-2011, 10:18 PM
  7. INDEX/MATCH Across Workbooks
    By SamuelT in forum Excel General
    Replies: 3
    Last Post: 01-17-2007, 02:00 PM

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