Articles

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 •


#1
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 •

#2
March 26, 2009 at 07:35:54

Also look at Named Range Pictures under Functions at that same site.

http://www.contextures.com/excelfil...


Report •

#3
March 26, 2009 at 15:58:27

Thanks Derby I'll get to work on it tonight!

Report •

Related Solutions


Ask Question