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 less
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 give
is 1, so it should fall under the third row (because 108 is between 105
and 110) and the number it should return is 2 because that is under the
#1 column.

Sounds pretty complex to me, hope someone can make sense out of it and
help me out, thanks :).


--
Jedispiff
------------------------------------------------------------------------
Jedispiff's Profile: http://www.excelforum.com/member.php...o&userid=32099
View this thread: http://www.excelforum.com/showthread...hreadid=518567

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




"Jedispiff" wrote
in message ...

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 less
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 give
is 1, so it should fall under the third row (because 108 is between 105
and 110) and the number it should return is 2 because that is under the
#1 column.

Sounds pretty complex to me, hope someone can make sense out of it and
help me out, thanks :).


--
Jedispiff
------------------------------------------------------------------------
Jedispiff's Profile:
http://www.excelforum.com/member.php...o&userid=32099
View this thread: http://www.excelforum.com/showthread...hreadid=518567

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


--
Jedispiff
------------------------------------------------------------------------
Jedispiff's Profile: http://www.excelforum.com/member.php...o&userid=32099
View this thread: http://www.excelforum.com/showthread...hreadid=518567

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.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )


"Jedispiff" wrote
in message ...

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 less
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 give
is 1, so it should fall under the third row (because 108 is between 105
and 110) and the number it should return is 2 because that is under the
#1 column.

Sounds pretty complex to me, hope someone can make sense out of it and
help me out, thanks :).


--
Jedispiff
------------------------------------------------------------------------
Jedispiff's Profile:
http://www.excelforum.com/member.php...o&userid=32099
View this thread: http://www.excelforum.com/showthread...hreadid=518567

Thanks for the help, made it work :)


--
Jedispiff
------------------------------------------------------------------------
Jedispiff's Profile: http://www.excelforum.com/member.php...o&userid=32099
View this thread: http://www.excelforum.com/showthread...hreadid=518567