Dugzilla
New Member
- Joined
- Oct 11, 2023
- Messages
- 25
- Office Version
- 2021
- Platform
- MacOS
(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.
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.