find number within a range

[Mona]

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

 

[T. Valko]

Try this:

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

 

[Mona]

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

 

[T. Valko]

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!