Index Match with duplicate names in the same column - Need correct formula.

[Dugzilla]

(I searched the forum but didn't find a solution that was meaningful.)

This is my current formula: =IFERROR(INDEX(Week_16!G:G,MATCH($A5,Week_16!B:B,0)),"DNP")

However, Week_16!B:B has duplicate names. I can get around this by filtering on Week_16!D:D but haven't been able to figure out the correct formula.

What would be the correct way to write the formula?

You all have been a huge help in the past and I appreciate your consideration.

 

[Fluff]

How about

=filter(Week_16!G:G,$A5=Week_16!B:B,"DNP")

 

[Dugzilla]

How about

=filter(Week_16!G:G,$A5=Week_16!B:B,"DNP")

=IFERROR(INDEX(Week_16!G:G,MATCH($A5,Week_16!B:B,0)),"DNP")

Week_16!G:G - is the data I want
$A5 is the player name I want to match
Week_16!B:B is the list of player names (This is the list with the duplicates)
The position of the players is in Week_16!D:D (say "QB")

Does this better explain what I need?
Thank you again.

 

[Fluff]

Does this better explain what I need?

No, because you still haven't said what you do want.

 

[Dugzilla]

My ignorance makes me nervous. Sorry.

I only want to return the name of the duplicate player that is a QB.

 

[Fluff]

In that case how about

=filter(Week_16!G:G,($A5=Week_16!B:B)*(Week_16!d:d="qb"),"DNP")

 

[Dugzilla]

Goodness... I would not have figured that out. Thank you for putting up with me.

 

[Fluff]

You're welcome & thanks for the feedback.