[SOLVED] Excel 2010 - Picking pictures from a table based on formula result

**r011in** · 11-22-2012, 06:34 AM

Here's an example of what I'm trying to achieve:

User enters a product name in a cell on sheet 1.
The product name has lots of detail attached to it in sheets 2, 3 & 4. This information gets drawn into various parts of sheet one to build up an information page.
Some of this information includes pictures, which I also need displayed on sheet 1.
I've been using VLOOKUP to gather information from the other sheets for display on sheet 1. This includes the names of the pictures I need displayed, however, I have been unable to display the pictures (even when I use a Define Name Table).
I have tried this method, but it returns an Invalid Reference error.
I have tried this method but it doesn't display the picture.
Please also bear in mind, this must work from a VLOOKUP result, not a drop-down list.

I have basic knowledge of Excel, but no knowledge of VBA. I'm willing to try VBA, or anything else which will get this done. If you need any further information, please don't hesitate to ask.

**Fotis1991** · 11-22-2012, 06:41 AM

No VBA here and step by step instructions.

http://www.youtube.com/watch?v=CEM0pp5SjMU

**r011in** · 11-22-2012, 08:12 AM

Thank you very much Fotis1991, that worked perfectly.

**r011in** · 11-22-2012, 12:04 PM

Just one more question Fotis, is there a way to hide the picture if you choose an option for which there is no associated picture? Using a generic picture or a blank is not an option.

**Fotis1991** · 11-22-2012, 02:57 PM

How to hide something that there is not exist??

If there is not picture will gives you an error. Use IFERROR(formula),"') to get a blank cell, OR

Put in the list a picture that says "No picture availamble" or something like this..