can you use VLOOKUP TO PRINT A PICTURE
 

I have set up a form in Excel with a VLOOKUP table. I want to expand the
VLOOKUP so that a picture is included. I set up the new column in VLOOKUP
and dropped in a hyperlink to a JPG file, but all it is printing the
hyperlink info, not the actual picture. Can a VLOOKUP a hyperlinked picture?
is there a better way?

can you use VLOOKUP TO PRINT A PICTURE
 

Programmatically............see JE McGimpsey's site for a method of showing

hidden pictures based upon a VLOOKUP value in a cell.

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



Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 06:38:02 -0700, Russell-stanely
wrote:

I have set up a form in Excel with a VLOOKUP table. I want to expand the
VLOOKUP so that a picture is included. I set up the new column in VLOOKUP
and dropped in a hyperlink to a JPG file, but all it is printing the
hyperlink info, not the actual picture. Can a VLOOKUP a hyperlinked picture?
is there a better way?

can you use VLOOKUP TO PRINT A PICTURE
 

The site is still not available, Gord - has been down for over a week
now.

Pete

On Jul 25, 9:09 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Programmatically............see JE McGimpsey's site for a method of showing

hidden pictures based upon a VLOOKUP value in a cell.

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

Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 06:38:02 -0700, Russell-stanely



wrote:
I have set up a form in Excel with a VLOOKUP table. I want to expand the
VLOOKUP so that a picture is included. I set up the new column in VLOOKUP
and dropped in a hyperlink to a JPG file, but all it is printing the
hyperlink info, not the actual picture. Can a VLOOKUP a hyperlinked picture?
is there a better way?- Hide quoted text -

- Show quoted text -

can you use VLOOKUP TO PRINT A PICTURE
 

JE replied in a different thread that he knows about the problem and is looking
into it.

Pete_UK wrote:

The site is still not available, Gord - has been down for over a week
now.

Pete

On Jul 25, 9:09 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Programmatically............see JE McGimpsey's site for a method of showing

hidden pictures based upon a VLOOKUP value in a cell.

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

Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 06:38:02 -0700, Russell-stanely



wrote:
I have set up a form in Excel with a VLOOKUP table. I want to expand the
VLOOKUP so that a picture is included. I set up the new column in VLOOKUP
and dropped in a hyperlink to a JPG file, but all it is printing the
hyperlink info, not the actual picture. Can a VLOOKUP a hyperlinked picture?
is there a better way?- Hide quoted text -

- Show quoted text -

--

Dave Peterson

can you use VLOOKUP TO PRINT A PICTURE
 

We will just have to wait.

I have a copy of the lookuppics workbook if OP would like one sent.

russel-stan

Email me personally..............change the DOT and AT as needed.


Gord

On Wed, 25 Jul 2007 16:56:16 -0500, Dave Peterson
wrote:

JE replied in a different thread that he knows about the problem and is looking
into it.

Pete_UK wrote:

The site is still not available, Gord - has been down for over a week
now.

Pete

On Jul 25, 9:09 pm, Gord Dibben <gorddibbATshawDOTca wrote:
Programmatically............see JE McGimpsey's site for a method of showing

hidden pictures based upon a VLOOKUP value in a cell.

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

Gord Dibben MS Excel MVP

On Wed, 25 Jul 2007 06:38:02 -0700, Russell-stanely



wrote:
I have set up a form in Excel with a VLOOKUP table. I want to expand the
VLOOKUP so that a picture is included. I set up the new column in VLOOKUP
and dropped in a hyperlink to a JPG file, but all it is printing the
hyperlink info, not the actual picture. Can a VLOOKUP a hyperlinked picture?
is there a better way?- Hide quoted text -

- Show quoted text -