Multiple Criteria to produce one output (Match and Vlookup)

I been having trouble figuring out how to get an output from two different criterias (Country and Type) from a different worksheet. What I want to do is to:

- On the Input tab I would like to put a country and a type (either x or y)
- Then I want to return the value that matches those two criterias lets say Country : China and Type: X , I want those values to be returned in the table located in first tab. ( See attached excel sheet)

I been trying to use the vlookup and the match together but I cant get it to work , any help would be appreciated.

Thank You Example.xls

Firstly, do away with merged cells. They wreak havoc with Excel fomulae. If you need them for dipslay pruposes use 'center across selection' instead

Use..
=INDEX(Data!$C$4:$M$15,MATCH(G3,Data!$C$4:$C$15,0),MATCH($E$7,Data!$C$4:$M$4,0)+(IF($E$8="y",1,0)))

See attached

First, in E3 of Data sheet add formula:

=LOOKUP(REPT("z",25),$E$4:E$4)&"_"&E5

copied across. This is to align the x and y to country for each column

Then in Inputs sheet, H4:

=IF(ISNUMBER(MATCH($E$7&"_"&$E$8,Data!$E$3:$M$3,0)),INDEX(Data!$E6:$M6,MATCH($E$7&"_"&$E$8,Data!$E$3:$M$3,0)),"")

copied down.