Excel help for my business product management.!?

so here is my situation.



my small business keeps all my products on a database, about 1000-1200 products.



the distributor i order from sends out their excel sheet/product list once a day or more with updated info {prices, descriptions, instock, etc.} but their data sheet has 20,000 + items on it, which is way more then i have.



if i have to buy software or an add-on that is fine, just link or tell the general name of what i am looking for, but here is my problem, i need to update my sheets by product name/UPC, NOT by row or column number.



lets say my upc is 123412341234, how would i have excel look at my sheet, and no matter what cell it is in, update the same row based off that upc. the column layout will never change, its the rows where the product is located that changes. so one day my upc 123412341234 might be row 5005, but next day it might be row 23, but it will always be COLUMN b, so how would i , or is there software that could recognize all of column B and say ';match upc in column B with upc in column C of distributor sheet'; and update all info in other columns of the same row accordingly';?



if this is confusing, try this.



product AAAA is 29.99, but distributor marked up priced to 39.99, so how do i update the price cell according to the product name?



thanksExcel help for my business product management.!?
As I see it you have a couple options, you can use inventory management software such as netsuite or fishbowl for quickbooks. The other decent option is to use access or other database software that easily let's you search and sort by content.Excel help for my business product management.!?
Hire a really good guy with Excel, a really really good guy. I'm so confused I get the idea but can't practically connect it visually. I'm having problems of my own, and I'm Excel certified by Microsoft.