one way:

http://www.mcgimpsey.com/excel/lookuppics.html

In article ,
".: usman :." <.: usman wrote:

hi there,
im using excel as part of coursework for my A-Level ICT, and i need to
somehow link images into the program. I have a list of names which i want
linked to images, so when i create a drop down list and click on a selection,
the image of the particular name will be displayed. I am just wanderin if
there are any solutions or ways to do this. It would be very helpful if you
can help me with my query!