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

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.