Find cell based on multiple identical criteria

mchri233

New Member
Joined
Oct 23, 2019
Messages
2
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.
PLAYERPOSTEAM
KirkWRARI
MooreWRCAR
FitzgeraldWRARI
ByrdWRARI
SamuelWRCAR

<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!
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,646
Office Version
365
Platform
Windows
Welcome to the MrExcel board!

Try something like this, copied down.

Excel Workbook
ABCDEF
1PLAYERPOSTEAMTeamARI
2KirkWRARIPosWR
3MooreWRCARList
Kirk
4FitzgeraldWRARIFitzgerald
5ByrdWRARIByrd
6SamuelWRCAR
List
 

Watch MrExcel Video

Forum statistics

Threads
1,099,142
Messages
5,466,925
Members
406,510
Latest member
wizekor

This Week's Hot Topics

Top