Formula Help

[ststern45]

I would like to know if a formula can be created for the following:

I have a value in cell A1 = 1052504

Since the value in cell A1 = 1052504 is greater than or equal to B2 (1048577) and less than or equal to C2 (2097152) the result would be 1 (cell D2).

Can a formula be created to calculate the above?

I have values in the following cells:

B1 = 0000001
C1 = 1048576
D1 = 0

B2 = 1048577
C2 = 2097152
D2 = 1

B3 = 2097153
C3 = 2704156
C3= 2

Thanks in advance.

 

[Tetra201]

Is this what you need?

=($A$1< B1)+($A$1<=C1)<b1)+($a$1<=c1)< html=""></b1)+($a$1<=c1)<>

 

[ststern45]

Thanks but I was looking for an Index and Match formula.
For example,
Index B1:D3
Match B1:B3>=A1, C1:C3<=A1
Result = 1 (cell D2)

105204 is greater than or equal to B2 1048577
105204 is less than or equal to C2 2097152
So the result would be 1 (cell D2)

Thanks in adavance

 

[ststern45]

OK found what I was looking for:

=INDEX(B2:F4,MATCH(1,(B2:B4<=B23)*(D2:D4>=B23),0),5)

Ctrl+Shift+Enter

The cell ranges do not match the cells I posted.