You're table *must* be sorted in ascending order. For negative numbers it
would look like this:

-10
-5
-1

Maybe you should explain in greater detail what results you expect!

--
Biff
Microsoft Excel MVP


"Mona" wrote in message
...
Thank you. This is a start. this works but when I put in negative
numbers,
it doesn't. ??

"T. Valko" wrote:

Try this:

=LOOKUP(D10,A1:A3,C1:C3)

--
Biff
Microsoft Excel MVP


"Mona" wrote in message
...
Hello-
My example data looks like this:
A1 B1 C1
1 4 100
5 9 200
10 12 300

In D10 I have value of 3. I would like to create formula if D10 is
greater
than A1 but less than B1 then select C1. So in this example it would
be
100

thanks