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