访问函数，将多个条件匹配到多个输出(或Excel)

I am wondering if there is a simple function that will be able to match certain criteria to various outputs. Quite hard to describe, but what I would want is something like:I am wondering if there is a simple function th