It is possible to vlookup an image?

S

SpielbergRules

Hello All,

You folks have helped me out immensely in the past. Not a new Excel
user here, but really stumped on this one.

I have a fairly elaborate invoicing sheet I made for my business of
printing backstage passes, credentials, etc.

On the customer proof copy, I'd like to be able to have thumbnail size
images of the product(s) they are ordering (the credential, the type of
lanyard, etc.)

So, I made a separate sheet in the workbook that has those small
images in each cell. The cell is big enough to hold the image without
any "spillover".

vlookup works fine for everything else text-wise, but I was wondering
how I could (or even if it is possible) to have it return an image as a
result.

If it isn't possible through vlookup, is it possible to do another way
without having to go crazy with VB programming?

Thanks to anyone who can help...

Mike
 
N

Niek Otten

Hi Mike,

Look here:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|
| Hello All,
|
| You folks have helped me out immensely in the past. Not a new Excel
| user here, but really stumped on this one.
|
| I have a fairly elaborate invoicing sheet I made for my business of
| printing backstage passes, credentials, etc.
|
| On the customer proof copy, I'd like to be able to have thumbnail size
| images of the product(s) they are ordering (the credential, the type of
| lanyard, etc.)
|
| So, I made a separate sheet in the workbook that has those small
| images in each cell. The cell is big enough to hold the image without
| any "spillover".
|
| vlookup works fine for everything else text-wise, but I was wondering
| how I could (or even if it is possible) to have it return an image as a
| result.
|
| If it isn't possible through vlookup, is it possible to do another way
| without having to go crazy with VB programming?
|
| Thanks to anyone who can help...
|
| Mike
|
|
| --
| SpielbergRules
| ------------------------------------------------------------------------
| SpielbergRules's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35981
| View this thread: http://www.excelforum.com/showthread.php?threadid=568941
|
 
S

SpielbergRules

THANK YOU THANK YOU THANK YOU!!! I cannot believe how simple tha
looks. I will try it immediately...

Thanks again!

Mik
 
Top