Use excel functions (vlookup, match, etc.) to identify name of product, color, size, and gender by comparing UPC from two separate spreadsheets.
[login to view URL] Inventory List contains only UPC (10 digits only)
2. Zip file contains detailed product info categorized by product, season/year (UPC = 12 digits but can ignore 1st digit and 12th digit)