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