Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Product Catalog

How can I create a product catalog?

I would like to enter the product# on cell A1 and see the (.jpg)
picture for that product number on the adiacent cell A2.

I have about 200 products and I keep my pictures on a \Images folder
separate hard drive named: Z:\Images.

Will be possible to accomplish this using a simple formula?
Something like a VLOOKUP that instead of returning a numeric value
will return a *.jpg picture on the cell...

Please Help.../ Thanks
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default Product Catalog

Hi Marco,

See JE McGimpsey's tutorial and samole workbook:

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

Note, however JE's caveat about c catalog application.


---
Regards,
Norman


"Marco Margaritelli" wrote in message
m...
How can I create a product catalog?

I would like to enter the product# on cell A1 and see the (.jpg)
picture for that product number on the adiacent cell A2.

I have about 200 products and I keep my pictures on a \Images folder
separate hard drive named: Z:\Images.

Will be possible to accomplish this using a simple formula?
Something like a VLOOKUP that instead of returning a numeric value
will return a *.jpg picture on the cell...

Please Help.../ Thanks



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Catalog merge from Excel; $ formatting srpd Excel Discussion (Misc queries) 0 February 12th 09 04:52 PM
45 RPM Record Catalog Ringmaster Excel Discussion (Misc queries) 10 November 18th 06 09:30 AM
Grouping entries in a catalog Helen McClaine Excel Discussion (Misc queries) 1 May 10th 05 11:48 PM
Product Catalog Marco Margaritelli[_2_] Excel Programming 0 July 20th 04 10:18 PM
Autofilter with VBA for Catalog? motoracer897 Excel Programming 3 March 5th 04 11:45 PM


All times are GMT +1. The time now is 09:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"