I recently saw a thread started in 2009 by BRISBANEBOB asking:
The thread was entitled: Insert image with IF statementIs it possible to insert an image (such as Picture1 which is the name of an image created by Insert>Name>Define) using an IF statement as in:
=IF(A1=B1,+Picture1,"")
Chance2 provide a solution the next day that clearly resolved BRISBANEBOB's question, although the thread is not marked Solved
The reason for posting this new thread is that the original thread was revived in the middle of last year and again today (09 January 2013). The thread has been viewed over 4000 times ... but the recent updates indicated some dissatisfaction with the explanation.
I decided to play around with the example which, I must add, worked straight out of the box, for my own benefit and edification. I have tried to clarify the explanation of the steps necessary and also how to create the necessary Named Ranges, which may be the source of the confusion.
The results of my efforts are attached for anyone who might want to implement something similar. I should thank BRISBANEBOB for asking the question, and Chance2 again for providing the solution (rep in the post )
Enjoy!
Regards, TMS
Bookmarks