automatic insert pictures

[Tim]

how can I automatic insert pictures by using a formular

example : if(a1=2000;"display picture 2000";" ")

there is a list of pictures with different names and I
want to insert one of these pictures automatically using
the name of the picture in a field.

 

[JE McGimpsey]

Worksheet functions can only return values to their calling cells.

You might find this an acceptable solution:

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