Pictures cannot be embedded in a cell and referenced by a formula like =A1

See John McGimpsey's site for one method using Event code, Data Validation
and VLOOKUP formula.

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

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

Alows for more than one picture(or same picture multiple times) 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 Wed, 27 May 2009 18:46:06 -0700, Hintzcm
wrote:

I would like to embed a picture into a cell in Excel, so I can put a function
in a different cell and have it appear there. For example, if I were to
embed the picture in cell A1 in cell F43 I could type =A1 and the embeded
picture would appear in cell F43. If I copy and past the picture or insert
it through the image menu it just floats over the cell. I've read about
inserting it as a comment or a hyperlink, but that is not what I'm looking
for. I'm don't want to mouse-over or click on anything, I just want the
picture to be there. Any suggestions?