Index Match error

[Dexir]

Greetings all! i have this sheet, i am trying to figure out this result with Index match, the (Red filled cell) for reference that what i want. with If condition its work, but too lengthy at all. please give a solution.
Thanks in advance!

Working2.xlsx
	A	B	C	D	E	F	G	H
1		Secondary	Primary
2	slab 1	10	100
3	slab 2	15	200
4	slab 3	25	300
5	slab 4	50	400
6	slab 5	100	500
7	slab 6	200	600
8	slab 7	700	700
9
10	Town Status	Deal Slab	Total Sales		Ok/Not Ok
11	Secondary	Slab 1	15		Ok		Not OK
12	Secondary	Slab 2	18
13	Secondary	Slab 3	28
14	Secondary	Slab 4	55
15	Secondary	Slab 5	106
16	Secondary	Slab 6	202
17	Secondary	Slab 2	15
18	Primary	Slab 1	101
19	Primary	Slab 2	201
20	Primary	Slab 3	301
21	Primary	Slab 4	401
22	Primary	Slab 5	501
23	Primary	Slab 6	601
24	Primary	Slab 7	701
25
Sheet1

Cell Formulas
Range	Formula
E11	E11	=IF(AND(INDEX($B$2:$C$8,MATCH($B11,$A$2:$A$8,0),MATCH($A11,$B$1:$C$1,0)>=$C11),(INDEX($B$2:$C$8,MATCH($B11,$A$2:$A$8,0),MATCH($A11,$B$1:$C$1,0))<=$B3)),"Ok","Not Ok")
G11	G11	=IF(A11=B$1,IF(AND(B11=A$2,$C11>=$B$2,C11<B$3),"OK","Not OK"))

 

[Dexir]

Thanks alot, but sorry to say that i am using MS Office 2016 in office. any alternate ?

 

[Fluff]

It would have helped if your profile had been correct.
Try

=IF(AND(C11>=INDEX($B$2:$C$8,MATCH(B11,$A$2:$A$8,0),MATCH(A11,$B$1:$C$1,0)),C11<IFERROR(INDEX($B$2:$C$8,MATCH(B11,$A$2:$A$8,0)+1,MATCH(A11,$B$1:$C$1,0)),1000)),"Ok", "Not Ok")

 

[Dexir]

Thanks alot it is working perfectly. and sorry for profile updation.
I updated now.

 

[Fluff]

You're welcome & thanks for the feedback.