PC Review


Reply
Thread Tools Rate Thread

how do i link a picture to a vlookup result?

 
 
=?Utf-8?B?Um9nZXIgb24gRXhjZWw=?=
Guest
Posts: n/a
 
      30th Oct 2007
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 With Quote
 
 
 
 
JE McGimpsey
Guest
Posts: n/a
 
      30th Oct 2007
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

 
Reply With Quote
 
=?Utf-8?B?Sm9lbA==?=
Guest
Posts: n/a
 
      30th Oct 2007
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 With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
how do i link a picture to a vlookup result? =?Utf-8?B?Um9nZXIgb24gRXhjZWw=?= Microsoft Excel Misc 2 31st Oct 2007 12:25 AM
Vlookup in vlookup - taking the result as array name =?Utf-8?B?U3VwcGVyRHVjaw==?= Microsoft Excel Worksheet Functions 2 2nd Jun 2007 11:05 AM
how do I insert picture into cell so vlookup can return picture? =?Utf-8?B?YWg=?= Microsoft Excel Worksheet Functions 1 1st May 2007 04:38 AM
vlookup shows result one cell above the expected result =?Utf-8?B?bWFyaWU=?= Microsoft Excel Worksheet Functions 7 14th Nov 2006 02:52 AM
vlookup based on random result returns incorrect result =?Utf-8?B?cmlja2F0?= Microsoft Excel Worksheet Functions 1 6th Dec 2005 01:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:32 AM.