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).

Type B Min	Type B Max		Value	Type
2	1		5	Type B
13	18		10	n/a
26	28		14	Type B
			16	Type B
			21	n/a
			24	n/a

<tbody>
</tbody>

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!