how do i link a picture to a vlookup result?

[Guest]

I use Vlookup all the time to return data regarding chemicals for example the
melting point. I also want to return the Hazard Pictogram (a hazard symbol
picture) so that the result of vlookup returns also the picture representing
the hazard - for example Toxic, Flammable, Irritant etc

 

[Niek Otten]

Look here:

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

and/or here

http://www.jkp-ads.com/articles/showpicture00.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I use Vlookup all the time to return data regarding chemicals for example the
| melting point. I also want to return the Hazard Pictogram (a hazard symbol
| picture) so that the result of vlookup returns also the picture representing
| the hazard - for example Toxic, Flammable, Irritant etc
|

 

[Gord Dibben]

Or here if you need multiple pictures.

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

Allows for more than one picture to be displayed on a sheet.

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

DV0049 - ClipArt Selection


Gord Dibben MS Excel MVP