Images and Lookups

  • Thread starter Thread starter @Homeonthecouch
  • Start date Start date
@

@Homeonthecouch

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
 
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
 
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
 
Gord,

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

Again thank you.

Andrew


"Gord Dibben" <gorddibbATshawDOTca> wrote in message 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
 
Back
Top