Emile du Toit
New Member
- Joined
- Mar 7, 2015
- Messages
- 22
Old but thorough product data
<tbody>
</tbody>
New but sparse product data
<tbody>
</tbody>
Combining best new and old data
<tbody>
</tbody>
I am trying to combine data from a detailed old product spreadsheet with much sparser data that is available for new products. Where the old data is available (here we are just going to look at the Description column) I want to add this data into the cell. Where a product is new though - and so it is not already detailed on my old spreadsheet - I want to add the new spreadsheet Description (as this is all there is). As you can see although the OLD and COMBINED spreadsheets have the same column order, the NEW one does not.
So in the third spreadsheet I am working in the Description column to populate the descriptions. In the first cell (intersection of the first product row and Description column) I am comparing the first SKU (product identifier) of the NEW spreadsheet with the entire SKU column of the OLD spreadsheet, to see if the SKU already exists in the OLD spreadsheet. If it does match then I want the cell to include the OLD spreadsheet Description data from the product with the SKU that matches the NEW product. If the NEW spreadsheet SKU does not match the OLD spreadsheet SKU (ie it is a genuinely new product) then I want to populate the cell with the NEW spreadsheet Description data. You can see I have added in the correct data for the COMBINED spreadsheet Description column.
The formula I tried (to populate D2) was:
=IF(ISNUMBER(SEARCH('NEW'!$D2,'OLD'!$B$2:$B$4)),INDEX('OLD'!$D$2:$D$4,MATCH('NEW'!$D2,'OLD'!$B$2:$B$4,0)),'NEW'!B2)
However, there must be an error as it returns the NEW descriptions whether or not the SKU's match.
Please help!!
| OLD | SKU | Title | Description |
| Product | XXX | Mr X | X description detailed |
| Product | YYY | Mr Y | Y Description detailed |
| Product | ZZZ | Mr Z | Z description detailed |
<tbody>
</tbody>
New but sparse product data
| NEW | Description | Weight | SKU |
| Product | A description simple | 20 | AAA |
| Product | Z description simple | 15 | ZZZ |
| Product | B description simple | 10 | BBB |
<tbody>
</tbody>
Combining best new and old data
| COMBINED | SKU | Title | Description |
| Product | A description simple | ||
| Product | Z description detailed | ||
| Product | B description simple |
<tbody>
</tbody>
I am trying to combine data from a detailed old product spreadsheet with much sparser data that is available for new products. Where the old data is available (here we are just going to look at the Description column) I want to add this data into the cell. Where a product is new though - and so it is not already detailed on my old spreadsheet - I want to add the new spreadsheet Description (as this is all there is). As you can see although the OLD and COMBINED spreadsheets have the same column order, the NEW one does not.
So in the third spreadsheet I am working in the Description column to populate the descriptions. In the first cell (intersection of the first product row and Description column) I am comparing the first SKU (product identifier) of the NEW spreadsheet with the entire SKU column of the OLD spreadsheet, to see if the SKU already exists in the OLD spreadsheet. If it does match then I want the cell to include the OLD spreadsheet Description data from the product with the SKU that matches the NEW product. If the NEW spreadsheet SKU does not match the OLD spreadsheet SKU (ie it is a genuinely new product) then I want to populate the cell with the NEW spreadsheet Description data. You can see I have added in the correct data for the COMBINED spreadsheet Description column.
The formula I tried (to populate D2) was:
=IF(ISNUMBER(SEARCH('NEW'!$D2,'OLD'!$B$2:$B$4)),INDEX('OLD'!$D$2:$D$4,MATCH('NEW'!$D2,'OLD'!$B$2:$B$4,0)),'NEW'!B2)
However, there must be an error as it returns the NEW descriptions whether or not the SKU's match.
Please help!!
