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