Problem inserting pictures from list

**kborgers** · 06-19-2012, 12:06 PM

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?

**DBY** · 06-19-2012, 02:53 PM

Hello
Take a look at the attchment for an idea how you might insert your pictures. Also, here is a link to a video which shows you how it's done.

http://www.youtube.com/watch?v=0sA6J1lTDfg

Hope this helps.
DBY

**kborgers** · 06-19-2012, 06:38 PM

Hey DBY, Many thanks indeed for your help - much appreciated! I've looked at the different approach in the video from Mr.Excel and your version of my spreadsheet - I'll play around with this a while but it certainly looks as though you've offered a great solution so thanks!