bill of materials

Originally Posted by stevekirk

BRYAN,

Not sure if it is working or not dont think so
look at the attached it will help better

it is one part used in 2 high level parts

total high level 124 of which 13 in stock
total number of the same lower part 124
one per high level
number of orders per lower level 124
i want the first 13 lower level order to be deleted as they are within the stock of the higher level part

steve

ok - thats a little different sheet, but, in Q2 put

=IF(MATCH("Description",A:A,0)>=ROW(A2),"",IF(ISERROR(VLOOKUP(D2,INDIRECT("F1:H"&MATCH("Description",A:A,0)),3,FALSE)),"",VLOOKUP(D2,INDIRECT("F1:H"&MATCH("Description",A:A,0)),3,FALSE)))

and fill that down, is that the 13 to remove?
---

added note, there are no spaces in that formula

Originally Posted by stevekirk

byran,

i did not copy the data correctly the description field is in column c
file changed
steve

Steve,

assuming you mean that the word 'Description' is in column C on the second heading as it is in the first, and that otherwise the columns are as shown, then in Q2 put

=IF(MATCH("Description",C$2:C$999,0)>=ROW(A2),"",IF(ISERROR(VLOOKUP(D2,INDIRECT("F1:H"&MATCH("Description",C$2:C$999,0)),3,FALSE)),"",VLOOKUP(D2,INDIRECT("F1:H"&MATCH("Description",C$2:C$999,0)),3,FALSE)))

Is that the 13 you seek?

---