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

See

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


In article <698E5428-DACC-4B3A-A054-(E-Mail Removed)>,
Roger on Excel <Roger on (E-Mail Removed)> wrote:

> 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

Vlookup can't return a picture. It can return the name of file that contains
a picture or name of the picture object in the workbook.

You will need to add a column to your table containing the name or the
picture. then code could be written that finds the picture and places the
picture in the correct location.

Once you decide you on the method (eiterh open a file to get the picture or
use a picture in the workbook) and give more details I will be glad to help.

"Roger on Excel" wrote:

> 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