Displaying Multiple Images based on Cell Value (Problem)

[avbanovice]

Hi all, I was able to get the code from the below thread (link) working perfectly on my computer but I deployed it out to a few other users and 1 of the images does not show up on their computer.

http://www.mrexcel.com/forum/showthread.php?t=384776

I used Plutos code and basically I have 4 pictures that change depending on the language chosen in a drop down on another sheet.

I'm using 2007 and I believe they are using 2010, but I haven't confirmed that yet. Could that be a problem?

Any thoughts on why it works ok for me but not others?

Here is my code.

Please Login or Register  to view this content.

In the cells where I want the pictures showing up I have the following formulas.

In C3 -> =IFERROR(VLOOKUP(Pricer!K2, PicTable2, 2, FALSE),"")
In C17 -> =IFERROR(VLOOKUP(Pricer!K2, PicTable3, 2, FALSE),"")
In C27 -> =IFERROR(VLOOKUP(Pricer!K2, PicTable4, 2, FALSE),"")

In B33 -> =IFERROR(VLOOKUP(Pricer!K2, PicTable5, 2, FALSE),"") (Not working on theirs but it does on mine.)

Thanks
stumped73

[JBeaucaire]

On the troublesome computer, click on B33 and use the Formulas > Evaluate Formula to step through that formula and see which calc fails.

Or post the file and let me look, I'm using Excel 2010.

[avbanovice]

On the troublesome computer, click on B33 and use the Formulas > Evaluate Formula to step through that formula and see which calc fails.

Or post the file and let me look, I'm using Excel 2010.

Ok thanks I'll give it a shot. Unforunately the other users are in remote locations so I need to set up a webinar just so I can watch them step through the formula. I'd send you the file but it's quite large and has lot of confidential info in it.

Thanks again