Matching an image file to a drop down box selection

[Ed Crawford]

Is there a method to display an image file in a cell (or cell range)
conditional on the selection from a drop down box?

For instance, to select a colour from the list, and have the colour
displayed in the column adjacent (as in colour swatches from a paint store,
or to select a car model, and to have an image of it displayed adjacent to
the selection).

Thanks,

Ed

 

[Dave Peterson]

JE McGimpsey shows a way at:
http://www.mcgimpsey.com/excel/lookuppics.html