Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
JWS Wholesale
 
Posts: n/a
Default 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

  #2   Report Post  
Paul Sheppard
 
Posts: n/a
Default


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

  #3   Report Post  
JWS Wholesale
 
Posts: n/a
Default


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

  #4   Report Post  
Bob Phillips
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine to Sheets... JFALK Excel Discussion (Misc queries) 2 June 29th 05 03:58 PM
HELP!!! combine 4 different sheets ??? TonyKA Excel Discussion (Misc queries) 0 May 13th 05 04:05 PM
How do I merge information from sheets on other files into the ma. jones021 Excel Worksheet Functions 0 April 20th 05 09:54 PM
Can I combine 100+ sheets from different workbooks into one worksh bootstrapgroup Excel Discussion (Misc queries) 0 April 8th 05 10:17 PM
hot to access deleted information in excel sheets Goeran Zaengerlein Excel Discussion (Misc queries) 3 January 18th 05 10:41 AM


All times are GMT +1. The time now is 09:57 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"