find number within a range

  • Thread starter Thread starter Mona
  • Start date Start date
M

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
 
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!
 
Back
Top