Returning row value based on multiple criterias in array (not tables). IF ? Lookup ?

This would be easy to figure out in a table, but I can't use one for this particular project (document attached to this post).

Basically, I'm trying to go through many different game results (cells B18:i196), finding if two teams played against each others, and return the result in the appropriate cell.

ie. Let's take cell Z8, so "Grenier" against "Legault". I need to go through row 18 through row 196, and find the row that has $B8 in column B, Z$4 in column C, and then return the value of column D (rec) from that specific line. Then copy/paste that formula all over U5:AD14. I think I know how I would do that in a table, but for some reasons, can't figure out how to do it in current sheet format.

Anyone willing to help will earn my eternal gratitude.