Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures to selections.

Alows for more than one picture to be displayed based upon a value or item
chosen from DV lists

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection

Edit the code to suit.


Gord Dibben MS Excel MVP

On Tue, 15 Jul 2008 07:25:00 -0700, DJDKAL wrote:

Thank you for the quick response. That works great if I have a couple of
pictures in the entire workbook. In this instance, I have hundreds (which
sounds like it might be a database feature, according to the website you
posted which is another demon for me to learn). In addition, there will be
multiple cases where I need to show two or more pictures with one lookup.
For example, I type a parcel number of a property into my input tab. The
other lookup formulas return the contact information of the owner, name,
telephone number, address, etc. of that property. I would like to show
multiple pictures of that parcel when I type the number.

"Peo Sjoblom" wrote:

Not without code, here's an example

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

--


Regards,


Peo Sjoblom

"DJDKAL" wrote in message
...
I am trying to see if there is a way to lookup a picture in one tab and
insert it into another tab all within the same worksheet. I have tried
the
embed function, as well as creating a hyperlink to the picture only to
find
the VLOOKUP just returns the text of the link. Please help.