Find cell based on multiple identical criteria

[mchri233]

Hello,

I'm trying to find names based on multiple identical criteria. For clarity I'm looking to find specific NFL players from an entire league.

For instance, there are 3 columns: Players/Position/Team. I want to pull each wide receiver (WR) from the Arizona Cardinals (ARI), subsequently.

PLAYER	POS	TEAM
Kirk	WR	ARI
Moore	WR	CAR
Fitzgerald	WR	ARI
Byrd	WR	ARI
Samuel	WR	CAR

<tbody>
</tbody>

<tbody>
</tbody>

My logic is to: (1) search based on team (ARI) and once matched, (2) search by position (WR).

How can I formulate excel so that it takes the subsequent player once one is selected?

Note: if played around with INDEX(MATCH), INDEX(MATCH)ARRAY, & INDEX(AGGREGATE).

Any input is greatly appreciated!

 

[Peter_SSs]

Welcome to the MrExcel board!

Try something like this, copied down.

Excel Workbook
	A	B	C	D	E	F
1	PLAYER	POS	TEAM		Team	ARI
2	Kirk	WR	ARI		Pos	WR
3	Moore	WR	CAR		List	Kirk
4	Fitzgerald	WR	ARI			Fitzgerald
5	Byrd	WR	ARI			Byrd
6	Samuel	WR	CAR
List