RE: VLOOKUP For Pictures?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Thank you.

This did work at the time.

Sorry it's taken so long to respond.


--
Dan Walters


"Ron Coderre" wrote:

The VBA solution provided by JE McGimpsey is the generally accepted BEST
approach:
http://www.mcgimpsey.com/excel/lookuppics.html


This is just an alternative if you don't want to use VBA:

Assumption: Pictures are stored on Sheet2 to be dynamically shown on Sheet1.

Select Sheet2 and turn off Grid Lines
(Tools>Options>View tab:Uncheck Grid Lines)
1)For each picture to be displayed:
1a. Insert>Picture from file. (select picture and put it in the ***).
1b. Select the range of cells that contains the picture.
1c. Name that range of cells, using the prefix "pic" followed by the
dropdown list text:
Example for a picture of an Elephant:
Insert>Name>Define
Name: picElephant

2)Build your data validation list on a cell in Sheet1 and pick one of the
items.

3)Create a dynamic range name that refers to that cell:
Insert>Name>Define
Name: ShowMyPic
RefersTo: =INDIRECT("pic"&Sheet1!$A$1)
...or whatever cell you chose.

4)Copy/Paste one of the pictures from Sheet2 to the display cell on Sheet1.

5)With the picture selected, type this in the formula bar, then press [Enter]:
=ShowMyPic

The picture will be replaced by the picture referred to by the dropdown list.

Each time you select a different item in the list, the associated picture
will appear in the picture box and resize appropriately.

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"DanielWalters6" wrote:

Is it possible to look up the value in a cell, and depending on that display
a small graphic from a table elsewhere in the spread***.

At the moment, I have a small "system" which when a user picks a value from
a combo box, it is then put into a cell, then a cell that is located next to
the drop down displays a description of the product. It does this by looking
up the value that's stored in the cell, within a VLOOKUP statement.

Is it possible to do this with photographs - could I include a small
photograph of the product?

TIA For any help
--
Dan Walters
.

Quantcast