Images and Lookups

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

@Homeonthecouch - 03 Apr 2008 23:52 GMT

Hello,

Is it at all possible to link an image to a cell with text in a lookup table and then have another cell call for
that info - display the text and the accompanying image?

Many thanks in advance.

Andrew

Reply to this Message

Pete_UK - 04 Apr 2008 00:06 GMT

JE McGimpsey shows how it can be done here:

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

Hope this helps.

Pete

> Hello,
>
[quoted text clipped - 4 lines]
>
> Andrew

Reply to this Message

@Homeonthecouch - 04 Apr 2008 00:16 GMT

Well as it happens, I did see this from a previous post but as I have a lookup table looking for flags it would make
at a longhand exercise too with inputting all the info. I also would have to link each flag to a number rather than
working it to text.

Thank you for the help Pete but on this occasion I think I need to revisit the drawing board.

Andrew

JE McGimpsey shows how it can be done here:

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

Hope this helps.

Pete

On Apr 3, 11:52 pm, "@Homeonthecouch" <m...@home.com> wrote:

> Hello,
>
[quoted text clipped - 4 lines]
>
> Andrew

Reply to this Message

Gord Dibben - 04 Apr 2008 04:08 GMT

If you have discounted John's lookuppics, perhaps

Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures to selections.

Alows for more than one picture to be displayed based upon a value.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection

Edit the code to suit.

Gord Dibben MS Excel MVP

>Well as it happens, I did see this from a previous post but as I have a lookup table looking for flags it would make
>at a longhand exercise too with inputting all the info. I also would have to link each flag to a number rather than
[quoted text clipped - 21 lines]
>>
>> Andrew

Reply to this Message

@Homeonthecouch - 04 Apr 2008 17:50 GMT

Gord,

Thanks for that I have downloaded the file and may have a go at that later on.

Again thank you.

Andrew

If you have discounted John's lookuppics, perhaps

Got to Debra Dalgeish's site for a sample workbook from Bernie Dietrick for
adding pictures to selections.

Alows for more than one picture to be displayed based upon a value.

http://www.contextures.on.ca/excelfiles.html#DataVal

DV0049 - ClipArt Selection

Edit the code to suit.

Gord Dibben MS Excel MVP

>Well as it happens, I did see this from a previous post but as I have a lookup table looking for flags it would
>make
[quoted text clipped - 21 lines]
>>
>> Andrew

Reply to this Message

Rate this thread: