Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i link a picture to a vlookup result? | Excel Discussion (Misc queries) | |||
how do I insert picture into cell so vlookup can return picture? | Excel Worksheet Functions | |||
vlookup shows result one cell above the expected result | Excel Worksheet Functions | |||
vlookup based on random result returns incorrect result | Excel Worksheet Functions | |||
Function IF / test / Picture result | Excel Worksheet Functions |