I have created a table that will give me the FLOOR value of number that
constantly varies.

For example if the number is 62 and the formula for the for the floor is
=FLOOR(62,18) the solution is 54. My table starts at 18 as the significance
and descends by .5 down to 3. What I want to do is create a formula that will
pick and put the significance in one cell based on a criteria that is user
entered in another cell 12 (being the significance) or less and the
difference between the result from that column (in the table) divided by 2 in
the next column. Like this perhaps. I have a possible of 50 rows (same
column) which will likely all have several different numbers.

Column A Column B
11.5 =(62-57.5)/2 which equals 2.25

My biggest problems a


1) my table is limited to the ability of .5 increments.

2) my result from column B can't be less than 1.25 or greater than 2.5

This gives me a very narrow window to work with but it is a must.

I tried this on a smaller version but I get #n/a as the result. O15 is the
significance.
=INDEX(Q16:AA26,MATCH(O15,Q16:AA26,0),1)




PLEASE HELP ME IM LOST


Thank You,


scottgorilla