Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Catalog merge from Excel; $ formatting | Excel Discussion (Misc queries) | |||
45 RPM Record Catalog | Excel Discussion (Misc queries) | |||
Grouping entries in a catalog | Excel Discussion (Misc queries) | |||
Product Catalog | Excel Programming | |||
Autofilter with VBA for Catalog? | Excel Programming |