Hello
I am sure this is already posted somewhere so if someone could just point me in the right direction that would be great.
I am working on a data feed spreadsheet that has over 6000 rows of data broken out into (for simplicity's sake, lets say) 4 columns
(sheet1):
id mpn weight sku
I have to update this sheet with a new set of data that has the same headers (sheet2).
First of all, I would like sheet 1 to pull the new data from sheet 2 without duplicating the values. However, it gets slightly more complicated:
Sometimes, info from the new feed (sheet 2) is needed to polulate existing blank values in the original sheet. In these cases, I need sheet 2 to recognize where to overwrite these blank values based on the info in other columns. I want sheet 2 to refer to sheet 1 and automatically populate these fields.
As an example:
Sheet 1 Headers:
id mpn weight sku
4 3 (blank) 1
Sheet 2 headers
id mpn weight sku
4 3 2 (blank)
I would like to tell excel that if the first 2 columns are identical to then go ahead and refer to the column values in the other sheet. The best excel nomenclauter I could come up with to explain this is:
"If column 1 value sheet 1 and column 2 value sheet 1 = column 1 value sheet 2 and column 2 value sheet 2, then populate column 3 value sheet 1 from column 3 value sheet 2"
and then I could switch it for column 4.
Thank you to anybody who can help with this!
I am sure this is already posted somewhere so if someone could just point me in the right direction that would be great.
I am working on a data feed spreadsheet that has over 6000 rows of data broken out into (for simplicity's sake, lets say) 4 columns
(sheet1):
id mpn weight sku
I have to update this sheet with a new set of data that has the same headers (sheet2).
First of all, I would like sheet 1 to pull the new data from sheet 2 without duplicating the values. However, it gets slightly more complicated:
Sometimes, info from the new feed (sheet 2) is needed to polulate existing blank values in the original sheet. In these cases, I need sheet 2 to recognize where to overwrite these blank values based on the info in other columns. I want sheet 2 to refer to sheet 1 and automatically populate these fields.
As an example:
Sheet 1 Headers:
id mpn weight sku
4 3 (blank) 1
Sheet 2 headers
id mpn weight sku
4 3 2 (blank)
I would like to tell excel that if the first 2 columns are identical to then go ahead and refer to the column values in the other sheet. The best excel nomenclauter I could come up with to explain this is:
"If column 1 value sheet 1 and column 2 value sheet 1 = column 1 value sheet 2 and column 2 value sheet 2, then populate column 3 value sheet 1 from column 3 value sheet 2"
and then I could switch it for column 4.
Thank you to anybody who can help with this!
