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