Index Match not working

[NSSKumar]

I have an excel sheet where I have different prices for the same product in different currencies and I am using Index Match formula, to reorganize the sheet for ease of calculations, but the result is the same. The result I get is as follows:

[TABLE="width: 318"]
<colgroup><col><col span="3"></colgroup><tbody>[TR]
[TD] [/TD]
[TD]JPY[/TD]
[TD]INR[/TD]
[TD]HKD[/TD]
[/TR]
[TR]
[TD]Product A[/TD]
[TD]2000[/TD]
[TD]2000[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Product C[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Product D[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Product E[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
</tbody>[/TABLE]

My existing excel sheet has details in vertical format like in below:

[TABLE="width: 254"]
<colgroup><col><col span="2"></colgroup><tbody>[TR]
[TD]Product A[/TD]
[TD]JPY[/TD]
[TD="align: right"]2000[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]INR[/TD]
[TD="align: right"]1200[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]HKD[/TD]
[TD="align: right"]128[/TD]
[/TR]
[TR]
[TD]Product B[/TD]
[TD]JPY[/TD]
[TD="align: right"]1800[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]INR[/TD]
[TD="align: right"]1080[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]HKD[/TD]
[TD="align: right"]115.2[/TD]
[/TR]
</tbody>[/TABLE]

Can soneone help? Thanks,

 

[Aladin Akyurek]

Repeat Product A for INR and HKD; do the same for Product B.

=SUMIFS(ValueRange,ProductRange,product,CodeRange,code)

should now work.