I almost reached the solution, but still require assistance. I have updated the formula to now compute:

=OFFSET(OFFSET(Table!$E$8,0,0,1,1),MATCH(Criteria1!$C9&Criteria2!$D9,Plan[Wirecentre]&Plan[Type],0)-1,0,COUNTIFS(Table[Criteria1Range],Criteria1!$C9,Table[Criteria2Range],Criteria2!$D9)).

The problem here is that it works if the data in the Criteria range is listed in order, but once the data within the criteria range is mixed, it gives a polluted list. It also seems to exclude the last item on the list.