How to return multiple results based on multiple criteria

Hi all, I have a spreadsheet with multiple lookups, and I'm not exactly sure how to make it work. I've looked in several places, but don't see anything that matches what I am trying to do (or it's not...