I have 2 worksheets from my supplier. One has ALL of the product
information that I need, excluding the cost of the items. The one WITH
the cost has little info on it, but I NEED the cost column. I know I
can copy and paste it to the first sheet, BUT I cannot trust the part
numbers to match. The second sheet is updated every 15 minutes while
the first on updates maybe monthly. So info on the sheet one is older,
but the info on sheet two is limited. I hope this makes sense cause I
am wasting serious man hours trying to combine the right info for me to
upload and to make sure all is correct is taking TOO long.

Is there a formula I can use to get the cost and part numbers off sheet
2, but all other related product info (descriptions, weights, etc) from
sheet one to match so I can upload the combined information to my site?


Basically I am taking some info from sheet 2 and most info from sheet 1
and combining it to sheet 3 for upload. The part numbers must match all
other respective info for that product. I cannot have product A with
product Q's weight and so on.

If this makes sense to anyone, please help, I have been up and down
these forums, saw a couple things close to what I need, but am not
enough of an expert to know how to make it all work.

Thank you in advance!


--
JWS Wholesale


------------------------------------------------------------------------
JWS Wholesale's Profile: http://www.excelforum.com/member.php...o&userid=25327
View this thread: http://www.excelforum.com/showthread...hreadid=394464