Excel lookup for images

March 25, 2009 at 17:27:08
Specs: Windows XP
I'm working on a project and have hit a snag. I've created a drop down menu to select a cell and then made several Vlookup comands to fill in data from a table. I thought I could use the Vlookup formula to retrieve the appropriate image from the table but it doesn't work on images.

Is there a command that will display an image based on what is selected from the drop down menu?

See More: Excel lookup for images

Report •

March 26, 2009 at 07:14:54
There is no built-in Excel function to do what you want, but someone has written some VBA code that might work.

Go here:

http://www.contextures.com/excelfil... and check out the 5th example under Data Validation.

Download the ClipArtEvent zip file and take a look at how they did it.

Report •

March 26, 2009 at 07:35:54
Also look at Named Range Pictures under Functions at that same site.


Report •

March 26, 2009 at 15:58:27
Thanks Derby I'll get to work on it tonight!

Report •

Related Solutions

Ask Question