Excel 2007 : Index and Match

I have attached a sample spreadsheet.

What I am looking to do, which I kind of have an idea, but I do not know how to incorporate the two matches. One has to be exact and the other is not an exact match.

In column A, I have a list of different products, then in Column B there is for each of those different products there is a Max group. In columns E, F, and G I have test results. Column G is what should be returned by the match of column E and F.

Let me know if there is any questions. I really do not know how to explain it.