Important information on 2 sheets, combine?
 

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

JWS Wholesale Wrote:
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!

Hi John

Assuming the both worksheets have the Part Number on, and that Sheet1
has all the product information on and Sheet2 has the cost information
on, you could use VLOOKUP, the formula would look like this:

=VLOOKUP(A2,Sheet2!$A$2:$J$7,7,0)

Where A2 is the cell on sheet1 with the part number, sheet 2 isthe
sheet with the cost data, $A$2:$J$7 is the range of the data on sheet2,
7 is the column containing cost data being the seventh column from the
left and the 0 ensures exact matches

Hope this helps, if not give a bit more info and I may be able to help

Paul


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=394464

ok, since I am new I hope you can bare with me.

I put that formula in (using my column #'s, etc.). I got an N/A, what
does this mean?

Sheet 1:
Product Product Line Description 1 Description 2 Price, etc
12
2.99
Sheet 2:
item_no restricted burst msrp map_price price_note, etc
12 15.99

Ok. I need the price from sheet one to be on sheet 2. The only info
that is on sheet 1 and not a sheet 2 is the "Price". Sheet 2 has
additional product info that sheet 1 doesn't have. If I can get the
"Price" to sheet 2, matching the "item_ no" it should line up with all
other relevant info for the "item_no", thus, I can upload all 15,000
products without worry that the 2,000 dollar product has an MSRP of
19.95.

I hope this clarifies, I know this must be tough without the info in
front of you. Thank you for your help


--
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

The #N/A means that there was no match. This is caused by one of two things

1) You have set the lookup correctly and the item doesn't have a price,
which can be reflected better with

=IF(ISNA(VLOOKUP(A2,Sheet2!$A$2:$J$7,7,0))," no
price",VLOOKUP(A2,Sheet2!$A$2:$J$7,7,0))

2) You haven't set the formula up correctly and you are not looking in the
correct columns to match it. But looking at the data you posted it does seem
that the key id is in column A in both.

BTW, the ,& in Paul's formula relates to the column in the table being
looked in that contains the data that you need to extract. Change to suit.

--
HTH

Bob Phillips

"JWS Wholesale"
wrote in message
news:JWS.Wholesale.1tje2i_1123657510.6876@excelfor um-nospam.com...

ok, since I am new I hope you can bare with me.

I put that formula in (using my column #'s, etc.). I got an N/A, what
does this mean?

Sheet 1:
Product Product Line Description 1 Description 2 Price, etc
12
2.99
Sheet 2:
item_no restricted burst msrp map_price price_note, etc
12 15.99

Ok. I need the price from sheet one to be on sheet 2. The only info
that is on sheet 1 and not a sheet 2 is the "Price". Sheet 2 has
additional product info that sheet 1 doesn't have. If I can get the
"Price" to sheet 2, matching the "item_ no" it should line up with all
other relevant info for the "item_no", thus, I can upload all 15,000
products without worry that the 2,000 dollar product has an MSRP of
19.95.

I hope this clarifies, I know this must be tough without the info in
front of you. Thank you for your help


--
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