IF statement with range of numbers

[ha95148]

Hoping you could help me with an IF statement with range of numbers.
For example, per the table below, if my value is between the low range (i.e. 137) and high range (i.e. 227), i want Excel to return "Level2", and so on

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]low
[/TD]
[TD]high
[/TD]
[TD]level #
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="class: xl67, width: 64, align: right"]137[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="class: xl67, width: 64, align: right"]227[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="class: xl67, width: 64"]Level2[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="class: xl67, width: 64, align: right"]228[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="class: xl67, width: 64, align: right"]318[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="class: xl67, width: 64"]Level3
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="class: xl67, width: 64, align: right"]319[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD]

<colgroup><col width="64"></colgroup><tbody>
[TD="class: xl67, width: 64, align: right"]456[/TD]

</tbody>

[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="class: xl67, width: 64"]Level4[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="class: xl67, width: 64, align: right"]457[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="class: xl67, width: 64, align: right"]639[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 64"]
<colgroup><col width="64"></colgroup><tbody>[TR]
[TD="class: xl67, width: 64"]Level5[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Nine Zero]

assuming your table starts at cell A1

in cell C2 enter this formmula

=IF(AND(A2>=137,B2<=227),"Level2",IF(AND(A2>=228,B2<=318),"Level3",IF(AND(A2>=319,B2<=456),"Level4",IF(AND(A2>=457,B2<=639),"Level5","NO CRITERIA MATCH"))))

and drag down

 

[mrshl9898]

With the value in D1

=VLOOKUP(D1,A:C,3,1)

 

[ha95148]

With the value in D1

=VLOOKUP(D1,A:C,3,1)

Wow, i didn't realize vlookup would work the same. This formula is much easier. Thanks @mrshl9898

 

[Georgie80]

With the value in D1

=VLOOKUP(D1,A:C,3,1)

I dont understand how this works, can you explain please

 

[Peter_SSs]

I dont understand how this works, can you explain please

Welcome to the MrExcel board!

Perhaps you need to do some general research/brush-up of the long-standing VLOOKUP function: VLOOKUP function