B
Big Dave
I have 2 worksheets in my workbook. The 1st worksheet is a datase of part
numbers and classification codes. It has about 30,000 part numbers and 100 or
more classification codes. The 2nd worksheet is where I enter part numbers to
get the classification code. I'm using a vlookup on sheet 2 to reference part
numbers on sheet 1. When I enter the part number, I also enter cost & weight,
and excel provides the correct classification code.
However, I need to summarize by classification the total cost & weight.
I have a table on sheet 2 that will do that, but I would like excel to
automatically populate the classification code. I was able to do this with
nested IF functions, but it stops at 7 or 8 variables.
In the column of classification codes, row 1 will always be row 1 in the
summary table. But the classification code in row 2 may or may not match row
1. Sometimes row 1 through 15 will be the same and row 16 will be different.
Or Rows 1-4 are the same, row 5 is different than rows 1-4, rows 6-10 are the
same as 5, and row 11 is the same as rows 1-4.
Is there a formula where excel can see a change in value and return that new
value?
numbers and classification codes. It has about 30,000 part numbers and 100 or
more classification codes. The 2nd worksheet is where I enter part numbers to
get the classification code. I'm using a vlookup on sheet 2 to reference part
numbers on sheet 1. When I enter the part number, I also enter cost & weight,
and excel provides the correct classification code.
However, I need to summarize by classification the total cost & weight.
I have a table on sheet 2 that will do that, but I would like excel to
automatically populate the classification code. I was able to do this with
nested IF functions, but it stops at 7 or 8 variables.
In the column of classification codes, row 1 will always be row 1 in the
summary table. But the classification code in row 2 may or may not match row
1. Sometimes row 1 through 15 will be the same and row 16 will be different.
Or Rows 1-4 are the same, row 5 is different than rows 1-4, rows 6-10 are the
same as 5, and row 11 is the same as rows 1-4.
Is there a formula where excel can see a change in value and return that new
value?