Excel Formula

[gheyman]

From	To	Range
5	9	5-9
10	24	10-24
25	49	25-49

Is there a formula that would look up a value in cell A1 (for example the value in A1 is 13) that would find the equivalent Range. If the value is 13 then the formula should result in "10-24". The values in the From column will always be less then the corresponding To value and there would only be one possible result. The above example is from a table that I have. Thanks

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E
1	From	To	Range
2	5	9	1-9	13	10-24
3	10	24	10-24
4	25	49	25-49
Sheet6

Cell Formulas
Range	Formula
E2	E2	=XLOOKUP(D2,A2:A4,C2:C4,,-1)