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

Look he

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

"Roger on Excel" wrote in message
...
|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
|

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


On Tue, 30 Oct 2007 16:59:41 +0100, "Niek Otten" wrote:

Look he

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

and/or here

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