THANKS FOR THE FANCY FORMULE Peo Sjoblom. IT WILL TAKE A LITTLE EFFORT TO
FIGURE IT OUT. This works nice for returning "12" which is one of the
problems I was trying to solve. I still have to deal with the negative issue.
I am currently using If statements which work fine but I have a feeling that
it isn't the most effecient method.

I am currently using:
b5 = -5555

=IF(B5=0,IF(C17=0, 0, IF(B5<0, "N.R.",VLOOKUP(B5,
StrapCapacity,2))),IF(B5<0, "N.R.",VLOOKUP(B5, StrapCapacity,2)))
This formula deals with the negative value

I feel that if this formula could deal with negatives it would look like this:
=VLOOKUP(B5, StrapCapacity,2)
much easier to manage



This is the result of your formul:
=INDEX(Capacity,MATCH(SMALL(INDEX(Capacity,,1),COU NTIF(INDEX(Capacity,,1),"<"&ABS(B5))+1),INDEX(Capa city,,1),0),2)

=12

b5 = -5555
It should be
= 5

-10000 5
0 6
1000 7
2000 8
3000 9
4000 10
5000 11
6000 12
7000 13
8000 14
9000 15


Goes this make sense?