| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Combine information about products from 2 spreadsheets
Hi Everybody, thank you in advance for your help :) I am trying to two seperate spreadsheets into one. The spreadsheets are two different versions of the same list. One is older and one is newer. The spreadsheets look like this. Spreadsheet 1 SKU #_______Category_______Keyword 123_________(Blank)________Preschool 234_________(Blank)________Classroom etc... Spreadsheet 2 (This is the newer spreadsheet and it contains new products that are not in the old spreadsheet.) SKU #_______Category_______Keyword 123_________School_________(Blank) 234_________School_________(Blank) 345_________School_________(Blank) New product not in Spreadsheet 1 I need to merge these two spreadsheets, to get the category data, and the keyword data into the same spreadsheet. As well as this, I need the new products that are only in spreadsheet 2 and do not have a match in spreadsheet 1 to show up in the merged spreadsheet as well. Can anybody help me out with this. Thank you very much. Will Taylor -- wstaylor81 ------------------------------------------------------------------------ wstaylor81's Profile: http://www.excelforum.com/member.php...o&userid=29495 View this thread: http://www.excelforum.com/showthread...hreadid=493522 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Combine information about products from 2 spreadsheets
On your spreadsheet with the new data, do a VOOKUP of the SKU's against the
SKU's on the old data. A #N/A will be returned for the new items. =VLOOKUP(new_sku_cell,range_of_old_sku's,1,false) "wstaylor81" wrote: Hi Everybody, thank you in advance for your help :) I am trying to two seperate spreadsheets into one. The spreadsheets are two different versions of the same list. One is older and one is newer. The spreadsheets look like this. Spreadsheet 1 SKU #_______Category_______Keyword 123_________(Blank)________Preschool 234_________(Blank)________Classroom etc... Spreadsheet 2 (This is the newer spreadsheet and it contains new products that are not in the old spreadsheet.) SKU #_______Category_______Keyword 123_________School_________(Blank) 234_________School_________(Blank) 345_________School_________(Blank) New product not in Spreadsheet 1 I need to merge these two spreadsheets, to get the category data, and the keyword data into the same spreadsheet. As well as this, I need the new products that are only in spreadsheet 2 and do not have a match in spreadsheet 1 to show up in the merged spreadsheet as well. Can anybody help me out with this. Thank you very much. Will Taylor -- wstaylor81 ------------------------------------------------------------------------ wstaylor81's Profile: http://www.excelforum.com/member.php...o&userid=29495 View this thread: http://www.excelforum.com/showthread...hreadid=493522 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Combine two spreadsheets with Different column headings | Excel Discussion (Misc queries) | |||
| Important information on 2 sheets, combine? | Excel Discussion (Misc queries) | |||
| Combine several spreadsheets for an emailmerge (perhaps using Acce | Excel Worksheet Functions | |||
| Combine query to count products with similar names | Excel Worksheet Functions | |||
| How do I pull information from multiple existing spreadsheets int. | Excel Discussion (Misc queries) | |||
Linear Mode
