Need a Formula to Review Two Criteria and Return Multiple Values

I need to write a "complicated" formula and don't have the first idea of what function to use so searching is not helping me. I'm down a rabbit hole and in need of help!    Gist: I have three col...