Index&Match wrong result

[lu1zuk]

sobe e desce teste.xlsx
	P	Q	R	S	T	U
2	Cargo		Horas metas	Pontos
3	Comandante de exercito	Aspirante 869353363815411760	30	10	Aspirante	869353363815411760
4	Capitao tenente	2Tenente 869353363815411761	35	20	2 Tenente	869353363815411761
5	Major	1Tenente 869353363823816714	40	30	1 Tenente	869353363823816714
6	Capitao tenente	Soldado 901201962765279232	45	10	Soldado	901201962765279232
7	Comandante de exercito	Taifero 901201959556616212	50	10	Taifero	901201959556616212
8	Soldado	Cabo 901201955903406171	55	10	Cabo	901201955903406171
9	1 Tenente	Capitao 869353363823816715	60	10	Capitao	869353363823816715
10	Comandante de exercito	Capitao Tenente 869353363823816716	65	10	Capitao tenente	869353363823816716
11	General de Divisao	Capitao de Corveta 869353363823816717	70	10	Capitao de Corveta	869353363823816717
12	Taifero	Capitao de Fragata 869353363823816718	75	10	Capitao de fragata	869353363823816718
13	2 Tenente	Capitao de Mar e Guerra 869353363823816719	80	10	Capitao de Mar e Guerra	869353363823816719
14	General de Divisao	Major 869353363823816720	80	10	Major	869353363823816720
15	1 Tenente	Sub Tenente 901201936555069510	85	10	Sub Tenente	901201936555069510
16	2 Tenente	Tenente Coronel 869353363823816721	95	10	Tenente Coronel	869353363823816721
17	Tenente Brigadeiro	Sub Oficial 901201929600901120	95	10	Sub Oficial	901201929600901120
18	Capitao	Coronel 869353363823816722	100	10	Coronel	869353363823816722
19	2 Tenente	Guarda Marinha 901201926312566845	100	10	Guarda Marinha	901201926312566845
20	General de Exercito	General de Brigada 869353363832180797	130	10	General de Brigada	869353363832180797
21	Major	Gen Divisao 869353363832180799	150	10	General de Divisao	869353363832180799
22	Major	Gen Exercito 869353363832180801	200	10	General de Exercito	869353363832180801
23	Aspirante	Com Exercito 869353363832180805	250	10	Comandante de exercito	869353363832180805
24	General de Exercito	Contra Almirante 869353363874131971	500	10	Contra Almirante	869353363874131971
25	Major	Tenente Brigadeiro 869353363874131972	500	10	Tenente Brigadeiro	869353363874131972
26	Aspirante
27	Aspirante	80
Planilha1

Cell Formulas
Range	Formula
T13:T14	T13	=LEFT(Q13,FIND(8,Q13)-2)
U3:U25	U3	=RIGHT(Q3,18)
P3	P3	=IFERROR(@INDEX(T$3:T$25,AGGREGATE(15,6,(ROW(T$3:T$25)-ROW(T$3)+1)/ISNUMBER(SEARCH(U$3:U$25,E3)),1)),"")
P4:P27	P4	=IFERROR(INDEX(T$3:T$25,AGGREGATE(15,6,(ROW(T$3:T$25)-ROW(T$3)+1)/ISNUMBER(SEARCH(U$3:U$25,E4)),1)),"")
Q27	Q27	=INDEX(R$3:R$25,MATCH(P3,T$3:T$25))

Hi, so i'm tryind to use index and match(my language is PT_BR) but i know the names for it in the EN_US soo, dont worry.
The question is, why in the Q27, my index/match returns the wrong vallue?
The idea is, check P3 to T3:T25, and match with R3:R25, the correct anwser would be 250(R23) but it is showing 80(R13), i don't know why and how to make it does it correctly. Help

edit (the part about iferror, its a thing from the main excel sheet, don't worry, nothing wrong there)

 

[Fluff]

You haven't specified the match type, so it's doing an approximate match.
Try

=INDEX(R$3:R$25,MATCH(P3,T$3:T$25,0))

 

[lu1zuk]

You haven't specified the match type, so it's doing an approximate match.
Try

=INDEX(R$3:R$25,MATCH(P3,T$3:T$25,0))

Thank you!

 

[Fluff]

You're welcome.