Results 1 to 3 of 3

Problem inserting pictures from list

Threaded View

  1. #1
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Cologne, Germany
    MS-Off Ver
    Excel 2010
    Posts
    156

    Problem inserting pictures from list

    I have a football fixture list with date, home venue and away team for each of Manchester United’s games next season. I also have a lookup table with each team’s badge. I’m trying to get the badge of each team appear when a date is selected from a dropdown list. This is or should be fairly straight forward. As you can see from the attached example, I have put two ‘holding pics’ in the places where I want the home and away team badge pictures to appear and named each of those accordingly with the ‘refers to’ completed with INDEX and Match functions to find the appropriate badge. However, when I select a holding pic and try and input the same ‘named name’ in the formula bar, I get the error message, ‘Reference is not valid’, but it is! Any ideas anyone?
    Attached Files Attached Files
    Last edited by kborgers; 06-19-2012 at 06:40 PM.

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