Excel - Return values based on multiple criteria in an input cell

Hello,  I am looking for a bit of help in regards to returning numbers from a set of values in a column. It is complicated to use just an IF function as it involves multiple criteria.  For ex., I wo...