+ Reply to Thread
Results 1 to 4 of 4

VLOOKUP- use a picture

  1. #1
    honyacker
    Guest

    VLOOKUP- use a picture

    I have the formula:

    =VLOOKUP($D$4,Database!$A$1:$AA$653,14,FALSE)

    Where in the destination cell, I want a picture.
    In other words, instead of taking the text "See Diagram", I want my actual
    picture in there.
    Is it possible?
    Thanks,
    Joe



  2. #2
    JE McGimpsey
    Guest

    Re: VLOOKUP- use a picture

    See

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

    In article <OS#[email protected]>,
    "honyacker" <[email protected]> wrote:

    > I have the formula:
    >
    > =VLOOKUP($D$4,Database!$A$1:$AA$653,14,FALSE)
    >
    > Where in the destination cell, I want a picture.
    > In other words, instead of taking the text "See Diagram", I want my actual
    > picture in there.
    > Is it possible?
    > Thanks,
    > Joe


  3. #3
    Ron Coderre
    Guest

    RE: VLOOKUP- use a picture

    The VBA solution provided by JE McGimpsey is the generally accepted best
    approach:

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


    Is that something you can work with?

    ***********
    Regards,
    Ron

    XL2002, WinXP-Pro


    "honyacker" wrote:

    > I have the formula:
    >
    > =VLOOKUP($D$4,Database!$A$1:$AA$653,14,FALSE)
    >
    > Where in the destination cell, I want a picture.
    > In other words, instead of taking the text "See Diagram", I want my actual
    > picture in there.
    > Is it possible?
    > Thanks,
    > Joe
    >
    >
    >


  4. #4
    honyacker
    Guest

    Re: VLOOKUP- use a picture

    Thank you. Exactly what I want.

    Joe


    "honyacker" <[email protected]> wrote in message
    news:OS%[email protected]...
    >I have the formula:
    >
    > =VLOOKUP($D$4,Database!$A$1:$AA$653,14,FALSE)
    >
    > Where in the destination cell, I want a picture.
    > In other words, instead of taking the text "See Diagram", I want my actual
    > picture in there.
    > Is it possible?
    > Thanks,
    > Joe
    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1