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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top