can I use vlookup on an object (pictueres?)

[Guest]

I have a spec book in excel that has about 100 items. Each spec has detail
data in a table that I use vlookup to get and fill in a form for the user
print out. I need a way to insert a picture of the item based on a code the
user inputs in a cell. really just like vlookup for pictures.

 

[Debra Dalgleish]

A Vlookup formula can't return a picture, because pictures float over
the worksheet, instead of residing in a cell.

J.E. McGimpsey has some code for displaying a picture based on the
contents of a cell:

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