I need to lookup the intersection of a single row value and a column defined by the intersection of 2 values. I wish I could say that I gave this a good attempt but I am empty handed.

In the below example:
Lookup a runner's time based on jersey color and week number
The weeks may appear in any order

Complex Lookup.JPG