Results 1 to 2 of 2

How to pull in an image using vLookup

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 ...

  1. #1
    New Member
    Join Date
    Mar 2013
    Posts
    34

    Default How to pull in an image using vLookup

    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.

  2. #2
    Board Regular Snakehips's Avatar
    Join Date
    May 2009
    Location
    Coventry UK
    Posts
    3,244

    Default Re: How to pull in an image using vLookup

    Tony

    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

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com