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.
[TABLE="width: 100"]
<tbody>[TR]
[TD]PLAYER[/TD]
[TD]POS[/TD]
[TD]TEAM[/TD]
[/TR]
[TR]
[TD]Kirk[/TD]
[TD]WR[/TD]
[TD]ARI[/TD]
[/TR]
[TR]
[TD]Moore[/TD]
[TD]WR[/TD]
[TD]CAR[/TD]
[/TR]
[TR]
[TD]Fitzgerald[/TD]
[TD]WR[/TD]
[TD]ARI[/TD]
[/TR]
[TR]
[TD]Byrd[/TD]
[TD]WR[/TD]
[TD]ARI[/TD]
[/TR]
[TR]
[TD]Samuel[/TD]
[TD]WR[/TD]
[TD]CAR[/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 272"]
<tbody>[TR]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

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