Complex Problem

  • Thread starter Thread starter Jedispiff
  • Start date Start date
J

Jedispiff

I have 12 columns of data, looking like this:

(At Least) (But Less than) 0 1 2 3 4 5 6 7 8 9 10
0 105 0 0 0 0 0 0 0 0 0 0
105 110 1 2 0 0 0 0 0 0 0
110 115 2 3 4 0 0 0 0 0 0
etc.
I have two things to pinpoint exactly which number I want on the left
the first is the number that falls in between the atleast and les
than, and a number between 0-10 that chooses which column to select.
eg. The first number they give is 108 and the second number they giv
is 1, so it should fall under the third row (because 108 is between 10
and 110) and the number it should return is 2 because that is under th
#1 column.

Sounds pretty complex to me, hope someone can make sense out of it an
help me out, thanks :)
 
It's not that complex but your posted table looks a bit strange, I doubt it
really looks like that?

--

Regards,

Peo Sjoblom

Northwest Excel Solutions

www.nwexcelsolutions.com

(remove ^^ from email address)

Portland, Oregon
 
Well, there are 132 more lines to it, and that's not exactly what it
looks like, but it's a good approximation
 
Hi

At start, dismiss LessThan column at all, and start, so your table will look
like this

AtL 1 2 3 4 5 6 7 8 9 10
0 0 0 0 0 0 0 0 0 0 0
105 1 2 0 0 0 0 0 0 0 0
110 2 3 4 0 0 0 0 0 0 0
115

The formula for conditions 108 and 1
=OFFSET(A1,MATCH(108,A2:A5,1),1)
,for 33 and 8
=OFFSET(A1,MATCH(33,A2:A5,1),8)
, etc.
 
Back
Top