INDEX(), MATCH() with multiple row Criteria

[bbernzy]

Please see attached for the issue. Thanks!
ExampleHelp.xlsx

[Glenn Kennedy]

Hi. This is what you need. It's an array formula and must be set using CTRL + SHIFT + ENTER and not just ENTER. Excel will add the curly braces, if it's working. You don't type them. If they don't appear hit F2 & try again...

[FDibbins]

bbernzy, I would ask that you give a bit more description in your post, rather than in your attached file. That way, members who are interested in in responding to your request, have some idea what you want - and can maybe ask questions or for more clarification

Many members will just look at a post like that and move on, not knowing if they could help or not, but not interested in opening your file to find out

Thanks for the understanding