Can I add a match function to Achieve a search

[Beh162]

I'm currently using this formula to provide me with the last three full entries in a row, but I wanted to see if I can add a match feature, where it will match the team in cell E14 with E2:E5 then run the current formula.
=INDEX($F$2:$S$2,COUNTA($F$2:$S$2)-COLUMNS($F14:F14)+1)

I assume Match would be a good option?

 

[FDibbins]

If you mean, can you add a "match" to find which column to pull the data from, yes you can - you just need to adjust the reference in the INDEX to include all the columns in the range

 

[Peter_SSs]

I wanted to see if I can add a match feature, where it will match the team in cell E14 with E2:E5 then run the current formula.

If all teams will have the same number of columns filled from the left, try this copied across and down.

Book1
	E	F	G	H	I	J	K	L	M
2	Team A	L	L	L	W	W	L	W
3	Team B	L	W	W	L	D	W	L
4	Team C	W	W	L	W	L	L	W
5	Team D	W	W	W	W	W	W	W
6
13
14	Team C	W	L	L
15	Team B	L	W	D
16	Team D	W	W	W
Last 3 (1)

Cell Formulas
Range	Formula
F14	=INDEX($F$2:$S$5,MATCH($E14,$E$2:$E$5,0),COUNTA($F$2:$S$2)-COLUMNS($F14:F14)+1)

If the teams could have different numbers of results:

Book1
	E	F	G	H	I	J	K	L	M
2	Team A	L	L	L	W	W	L	W
3	Team B	L	W	W	L	D
4	Team C	W	W	L	W	L	L	W
5	Team D	L	L	L
6
13
14	Team C	W	L	L
15	Team B	D	L	W
16	Team D	L	L	L
Last 3 (2)

Cell Formulas
Range	Formula
F14	=INDEX($F$2:$S$5,MATCH($E14,$E$2:$E$5,0),COUNTA(INDEX($F$2:$S$5,MATCH($E14,$E$2:$E$5,0),0))-COLUMNS($F14:F14)+1)