Display image based on cell value

[herrma29]

Hello,

I am laying out a build book for a product line. I have 15 or so concrete sinks, each with different designs. I want to be able to select a style of sink from a drop down list (brought in from another sheet) and then display a 4" X 6" image saved in the same folder as the workbook.

I am having a hell of a time figuring out how to do this.

My workbook is laid out as follows:

Sheet2
[TABLE="width: 308"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Sink Name[/TD]
[TD]Sink Description[/TD]
[TD]Sink Image[/TD]
[/TR]
[TR]
[TD]Bay_Wave[/TD]
[TD]Large wave single sink[/TD]
[TD]Bay Wave.jpg
[/TD]
[/TR]
</tbody>[/TABLE]

Sheet1
Dropdown list in cell A1, which references the sink name column in sheet 2
Cell A2 contains the image file name from a lookup of cell A1


Any help is greatly appreciated!

Thanks,
Chris

 

[cooper645]

I have used the information here http://www.excel-bytes.com/photos-tied-to-dropdown-list-selection-in-excel/ before to do the same thing for inserting signatures dependent on names in dropdown