auto updating pictures in charts with lookup function

[marksixel]

I have built a workbook that automatically updates data throughout the
workbook when I change a three letter code, however, the updated data
is client specific and I would like to have the client logo (picture
file) update with the data. Is there any way to do a lookup table or
other? to have the picture tied to the three letter code so the picture
changes with the data.

Thanks

Mark

 

[Andy Pope]

Hi Mark,

You can not get a particular picture to appear as the result of a
formula. You can do it with some VBA code placed in the correct
worksheet event.

As an alternative I have an example of a chart that will display a
selection of pictures dependant on cell formula. It may suit your
requirement.
(http://www.andypope.info/fun/picviewer.htm)

Cheers
Andy