If a value is included in a range between 2 cells return value related from another range

[nunomd]

Hi. I would like to use a excel formula to resolve this problem.
Column C is the anwser I pretend.
In the same cell it will return the name of the correct range.
Ex: Between 200 and 300 there are numbers involved that are included in Range 1 and Range 2 (see second table)

Cell	A	B	C
1	From	To	Result: (How to return this value?)
2	200	300	Range1, Range2
3	301	400	N/A
4	401	500	N/A

<tbody>
</tbody>

Table to Check Value to Return:

Cell	A	B	C
1	120	280	Range 1
2	281	300	Range 2
3	600	650	Range 3

<tbody>
</tbody>

Thank you.
Best regards

 

[nunomd]

Hi. I would like to use a excel formula to resolve this problem.
Column C is the anwser I pretend.
In the same cell it will return the name of the correct range.
Ex: Between 200 and 300 there are numbers involved that are included in Range 1 and Range 2 (see second table)

Cell	A	B	C
1	From	To	Result: (How to return this value?)
2	200	300	Range1, Range2
3	301	400	N/A
4	401	500	N/A

<tbody>
</tbody>

Table to Check Value to Return:

Cell	A	B	C
1	120	280	Range 1
2	281	300	Range 2
3	600	650	Range 3

<tbody>
</tbody>

Thank you.
Best regards

Hello, can anybody help me in this question?
Thank you!

 

[nunomd]

Hello, can anybody help me in this question?
Thank you!

Does anyone knows?

 

[thisoldman]

A lookup table can help you:

*	A	B	C	D	E
1	Low limit	Range
2	0	Range 1		My Number	300
3	201	Range 2		My Range	Range 2
4	301	Range 3
5	401	Range 4
6	501	Range 5

<tbody>
</tbody>

In cell E3, any of these formulas will work:

=VLOOKUP(E2, $A$2:$B$6, 2, 1)
=LOOKUP(E2, $A$2:$A$6, $B$2:$B$6)
=INDEX($B$2:$B$6, MATCH(E2, $A$2:$A$6, 1))