Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]() 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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combine to Sheets... | Excel Discussion (Misc queries) | |||
HELP!!! combine 4 different sheets ??? | Excel Discussion (Misc queries) | |||
How do I merge information from sheets on other files into the ma. | Excel Worksheet Functions | |||
Can I combine 100+ sheets from different workbooks into one worksh | Excel Discussion (Misc queries) | |||
hot to access deleted information in excel sheets | Excel Discussion (Misc queries) |