Check if value falls within any two values in the same row

[iondrt]

I'm trying to come up with a formula to check if a value falls within any set of values in a range. This shows what I would like to display but I need a formula for the "Type" column on the right. The trick is I cant just MIN-MAX the 3 rows because I will be adding more rows in the future; so I really need something that can check between table columns (I'm using a table Type B Min and Max).

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Type B Min[/TD]
[TD]Type B Max[/TD]
[TD] [/TD]
[TD]Value[/TD]
[TD]Type[/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]5
[/TD]
[TD]Type B[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]18[/TD]
[TD][/TD]
[TD]10[/TD]
[TD]n/a[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]28[/TD]
[TD][/TD]
[TD]14[/TD]
[TD]Type B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]16[/TD]
[TD]Type B[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]21[/TD]
[TD]n/a[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]24[/TD]
[TD]n/a[/TD]
[/TR]
</tbody>[/TABLE]


Thanks for reading!

 

[wideboydixon]

Book1
	A	B	C	D	E
1	Type B Min	Type B Max		Value	Type
2	2	7		5	Type B
3	13	18		10	n/a
4	26	28		14	Type B
5				16	Type B
6				21	n/a
7				24	n/a
Sheet1

Cell Formulas
Range	Formula
E2	=IF($D2<=INDEX($B$2:$B$1000,MATCH($D2,$A$2:$A$1000,1)),"Type B","n/a")

WBD

 

[iondrt]

Below is what I used in my sheet... but first a few clarifiers:
AK19=value
150 Start=Type B Min
150 End=Type B Max


=IF(AK19<=INDEX(Table1[150 Start],MATCH(AK19,Table1[150 End],1)),"Type B","")

The bold/underlined part goes #N/A but every thing else goes fine. Is there something wrong with my formula or should I be looking at my table?

 

[iondrt]

Update:

turns out all I had to do was flip the direction to get it to work

from: =IF($D2<=INDEX($B$2:$B$1000,MATCH($D2,$A$2:$A$1000,1)),"Type B","n/a")

to: =IF($D2>=INDEX($B$2:$B$1000,MATCH($D2,$A$2:$A$1000,-1)),"Type B","n/a")

thanks for the help!