how do i link a picture to a vlookup result?

[Roger on 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

 

[JE McGimpsey]

See

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

 

[Joel]

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.