VlookUp or Match

Dear All,

May I request for your help please?

I am trying to get a data if 2 criteria is a match, for example if the Currency is USD and the item is $5 Load Denomination the amount reflected should be 5$, should I use v-lookup or match? If its v-look up can you please teach me how as I do not know how to do v-lookup with multiple criteria? If its match or something else can anyone teach me how because I simply dont know how to do use other formulas.
I have attached herewith the excel sample for easier reference.

Thanks.

Francis

try:
=SUMPRODUCT(('Product List'!$A$5:$A$125=$E$3)*('Product List'!$B$5:$B$125=$B5),'Product List'!$D$5:$D$125)
in E5 and copy down.
This will only give the correct result if there is only one match of currency/product name; if there is more than one match then those values will be summed.

Put consideration to a pivot table, it's a lot easier.