Check for certain values and make a new

[elmnas]

Hello all VB Members,

I should need help with a code,
The thing is I have got a workbook that contains two sheets “Statistics” and “Prices”
and I need a function that check for certain values.
For each Row in Sheet “Statistics” Check the values in each row for Column H and I and J
Example:
H1:SWE
I1:GER
J1:25
Picture(Sheet Statistics)

(all these 3 values are on same row (Row1))

For Each Row in Sheet “Prices” Check for the values but in this case instead SWE=(Column A) and Ger (Column B)
When found multiple the value 25 (Column J1, Sheet “Statistics”) * G1:3 (Sheet”Prices”)
Represent the result in Sheet “Statistics” same row but Column “N1”
Picture (Sheet Prices)

The thing is…
As the example I showed you (H1:SWE) and (i1:GER)
those values can be anything as so long they match the same values in sheet “prices”
Could someone help me ?
Thank you in advance