Nikki,

In this context the word 'Pull' doesn't mean much to me. What are the inputs
to the formula you require and from those inputs what result do you expect?

Mike

"Nikki" wrote:

Can anyone help me set up the lookup to pull <0 as shows in the table below?
What I have so far is -0.01 but it's not pulling anything. Thanks for your
help.

-0.01 <0
0.00 0 - 9.9
0.10 10 -19.9
0.20 20 - 29.9
0.30 30 - 39.9
0.40 40 - 49.9
0.50 50 - 59.9
0.60 60 - 69.9
0.70 70 - 79.9
0.80 80 - 89.9
0.90 90 - 99.9
1.00 100 +