QChris -

Say you put the value1 in cell K1 and value10 in cell L1, and your data
starts on row 2. Then put this in cell L2:

=IF(AND(K2=$K$1,K2<=$L$1),K2,"")

This will cause cell L2 to show the value of cell K2 if it is between the
values in cells K1 and L1. You can copy/paste or drag this cell down the
column and then copy/paste the values into columns J, N, and P. I am
assuming they all use the same value1 and value10 you put in cells K1 and L1.
If not, you can adjust the formula for each column before copying it down.

That's the icing. I am not sure what your cherry request is or where the
data you would use is to help with that one.

--
Daryl S


"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.