This is the table layout I was going to use to display results:
I've entered results, 2100 etc, but it's a clever formula I'd like to go in
there.

Col I Col J
SECTION 1
Total parts 51 (i've got this formula)
length qty
2100 32
569 10
235 3
234 6
etc.

Does this help??

"QChris" wrote:

Hi,

A new user to this site. Been learning a lok lately, but stuck now!

I have a sheet where i want to look for "value1" to "value10" in columns I,
K, M, O.

Once a particular value is found, I want it to display the value (numerical)
in the right hand column, J, L, N, P.

But I also want it to count how many parts are require by looking at the
number enterred in the same row but column D.

Basically, it's a cutting list with different profiles, lengths and
quantities and I'd like a summary of each profile, with each cut length
required and quantity required.

On a really, really, really, complicated matter, is it possible to write a
formula to auto select these in best material usage, i.e. stock material
lengths are 4m, 4.25, 4.8m?

Part 1 is the icing, part 2 is the cherry.