Combining IF(AND

kdwork 

It would be easier to help you if you helped us by posting a copy of your actual spreadsheet. With just the formulas, you're asking (no, "forcing") your reader to visualize the tables that you're referring to in your MATCH functions, among other things.

That aside, it may well be that the IFS function would be more suitable than a really complex combination of these two already-difficult-to-decipher formulas. With IFS you can specify, sequentially, condition+result pairings that satisfy various combinations of conditions. Here's the syntax:

=IFS (test1, value1, [test2, value2], ...)

You clearly know how to write formulas, so you might want to give that a try. If you need further help, though, I'd recommend posting a copy of the workbook you're working with, so long as it contains no confidential information.