2 criteria lookup from table, to matrix

[JuJuBe]

I need to lookup data in a table type data set and return it to a matrix style data set. If it was the other way around it would be easy to do with an Index(Match but I'm lost with going the other way.

In the example spreadsheet my formula would be entered in cell B2 of the 'Matrix' worksheet and would be looking up from the 'Data table' worksheet based on both the item # and color. In the case of cell B2 it would return 'COMET'.

Many TIA!