This is a discussion on How to pull in an image using vLookup within the Excel Questions forums, part of the Question Forums category; Hi All, I hope this does not require VBA etc. I have a cell with a drop down box in ...
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.
Take a look at this....Excel Magic Trick 882: Excel 2007 Bitmap Image Lookup Picture INDEX & MATCH functions - YouTube
Hope that helps.
AbUsing Excel 2002, 2007
This line will be updated just as soon as I come up with something, original, witty, profound or interesting. Please don't hold your breath!
Please remember - we cannot see your workbook nor read your mind.
Help us to help you, post clear detail of what you have and what you want - from the start.
A screen shot can save a thousand words!
Post a screen shot with one of these: Excel Jeanie, MrExcel HTML Maker
If posting VBA code, please use Code Tags - see: here