Conditional Images

[camz100]

Trying to get this method to work, but no luck. Is there something missing from the instructions (perhaps a step that's obvious to experts, but not to others)?

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

The sample sheets works, but when I try to create my own from the ground up, no luck.

I make sure the VB code points to the correct cell (example states F1). I ensure that the named range is spot on.

I've tried it with pictures named 'Picture 1', 'Picture 2' etc. and tried it with other names. The closest I get is that all the images disappear, but no image (regardless of the contents of the VLOOKUP reference cell appears. Instead, I get the text 'Picture 1' etc.

Do I need to name the pics or declare them somehow?

Thanks.

Edit: Excel 2007

[contaminated]

Hi See post # 2 here

[camz100]

Thanks for that. I've got 114 images across 14 different calcs to make, so I'll say thanks upfront and hope it all works.