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.