hopefully this won't wrap.

line model
1 750
2 745
4 750

Size Holes model Strokes
578 3 745 48
621 2 745 50
621 3 750 36
631 3 745 52

(the above columns are a-f, just moved so
outlook express doesn't wrap)

in the example i need a formula for,
the 1 for the line number and the 621 for the size are
entered as values in separate columns.

for my test case, i need a formula that can lookup the line number
(1 in this case) get the model number (750 in case) and return
the number of strokes for 621 model 759 (36 in this case) and place
it in the same row as the 1 and the 621.

i thought maybe 2 lookups or and index match formula.

can someone help?

--


Gary