I have an "Input sheet" with various bolt diameters, bolt grades & bolt
lengths.
example:
D E G H
J
Dia. Grade (Flat Washer) (Beveled washer) Length
..625 A325 black 1
1.5
..5 A325 galv 1
1.75
..75 SAE 1
2.0
..75 A325 galv 1
2.25
..75 A325 black 1
2.0

In the output sheet (same workbook) one area is assigned for each bolt
grade that has a flat washer, one for beveled washer:
Sample:
A325 HEX HEAD BOLT ASSY (Galv with Nut & Flat Washer)
A B C
Dia Length Qty
row 19 (formula ?) (formula ?)
row 20 (formula ?) (formula ?)
row 21 (formula ?) (formula ?)
etc. etc.
I column "C" there is a formula that will give a quantity for that specific
bolt grade providing I manually input the "bolt dia" in "A" and the "bolt
length" in "B" to match the information on the input sheet.
I would like to retreive the Dia & length in the first row and some how in
the second row the formula needs to look for different bolt dia that may have
different or same length as the previous row and so on. Column "C" will
simply give me a quantity for those bolts.

From previous posting I tried pivot table suggestions but my brain just
caanot get arround this.

Could someone help please, I'm realy desperate.

Thanks

Serge