• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

need help to make catalog in excel

yahya_jogja

New Member
Hi. I need help to make catalog product in excel. with rules is

Picture, Code, Product Name, Qty, Unit Price, Total Price.


Have alrady make the document but need some help.

1. I want if i type the code then will appear picture, Product name, unit price.

2. and when i type the Qty then Total price will appear to from unit price x Qty

3. its most like POST program.

thanks 4 the answere

sorry my english is not good.
 
I would setup a table on it's own sheet with all the columns you mentioned, including pictures for each item

I would name all the columns and make them Dynamic (auto expanding)

The pictures will all need names


Then use a series of Index(Match(...) equations to get the numbers and text out


A good description of Index(Match(...) is at

http://www.mrexcel.com/articles/excel-vlookup-index-match.php


A good description on retrieving pictures is found at

http://www.westnet.net.au/balson/ModellingExcel/VisualModelling.shtml


Good Luck
 
You can use it this add in for Excel


http://excel-image-assistant.com/default.aspx


Just a few clicks and catalog is ready.
 
Back
Top