How to pull in an image using vLookup

[kyleball]

Hi All,

I hope this does not require VBA etc.

I have a cell with a drop down box in C4. When 'Star' is selected, I would like C1 to show a picture of a star. When 'Moon' is selected in C4 I would like C1 to show a picture of a moon and so on.

I was just hoping I could do a simple IF formula or vLookup; but it just returns a 0. Are there any simple ways that I could get it to pull in the pictures?

For further information - there are 14 names I want to do this for (like star, moon etc). For my test I had the 14 names in columns and next to them the pictures.

 

[Snakehips]

kyleball,

Take a look at this....Excel Magic Trick 882: Excel 2007 Bitmap Image Lookup Picture INDEX & MATCH functions - YouTube

Hope that helps.