You would need VBA, here's one solution


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


it's not IF function per se but you you can use a lookup instead of an if
function
in most cases
--

Regards,

Peo Sjoblom



"Scott" wrote in message
om...
is there a way to write a
statement in Excel (like an IF Statement), that would display a
specific picture if a certain #/word/etc is typed in a cell? For
example in A1 if I typed in ball, it would automatically bring up a pic
I have saved of a ball in B1, whereas if I typed dog, it would put a
dog in B1, etc..? If you know how to do this can you PLEASE email me
at as its hard for me to check the Ngs at work...
Thanks in advance
Scott