Home |
Search |
Today's Posts |
#1
|
|||
|
|||
UPC info in Excel
OK, I always catch flack from my buddies because I always try and do crazy things with Excel. Here is one of those ideas. I hope someone can help me. Goal: Be able to compile a text list of my CD collection. My idea/solution: Enter the UPC codes from the CDs and use Excel to retreive the name info. I have found a website (http://www.upcdatabase.com/item.pl?upc=) where you can enter in a UPC code after the = and it will return a brief description of your item. The returned data is very standard and is in text format. My general theory is to have a cell to enter my UPC and have some type of formula/tool that will lookup that UPC and return the contents of the description field into another cell. I hope that I have described this accurately. The idea is a bit wacky but I am sure there is a way to do it. Thank you all in advance! Rich -- rreynolds63 ------------------------------------------------------------------------ rreynolds63's Profile: http://www.excelforum.com/member.php...o&userid=26737 View this thread: http://www.excelforum.com/showthread...hreadid=399925 |
#2
|
|||
|
|||
Scanning around on that same website,
http://www.upcdatabase.com/ one of the offerings is a download of the database that drives it. So you could avoid the web interface entirely, and use Excel or Access to do some lookups. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do i change info in all my cust cards in excel in one go | Excel Discussion (Misc queries) | |||
Extracting info from word and displaying in an excel spreadsheet | Excel Discussion (Misc queries) | |||
Difference in number of Excel NewsGroups | Excel Discussion (Misc queries) | |||
Where can I find advanced info on Excel Charts? | Charts and Charting in Excel |