Hi

I'm trying to look down 4 columns for "value 1" to "value 10" (column
I,K,M,O).

upon finding, for example, "value 1", it then lists the numerical value
found in the right hand column (J,L,N,P).

It also wants to count how many pieces required by looking at the value in
the same row but column D.

In summary, I would, if poss, like it to auto display all the different
steel profiles, with all the different cut lengths and to total up all the
cut lengths.

Makes sense??

Thanks for any help on this one!