how do i link a picture to a vlookup result?
 

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

how do i link a picture to a vlookup result?
 

See

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


In article ,
Roger on Excel <Roger on 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

how do i link a picture to a vlookup result?
 

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