Variable materials and prices formula

Hi Everyone

I have attached a sample workbook to try and explain my challenge.
In cell F:2 I need a formula that uses the values in cell A:2 and Cell C:2.
These values change according to what the user inserts. The formula needs to cover a wide spectrum of variables.
eg: IF cell A:2(PRODUCT) = "WOOD"
AND cell C:2(PRODUCT) = 3
THEN = cell B:2(PRICES) ie: R2.00


OR

IF cell A:2(PRODUCT) = "WOOD"
AND cell C:2(PRODUCT) = 6
THEN = cell C:2(PRICES) ie R4.00

Etc Etc

Once I have a formula worked out I need to copy it down in column F.

I have inserted a formula in F:2 , but this only has one variable .
So basically the formula could be something like this I think.


=IF(AND(A:2="WOOD",C:2=3),PRICES!B:2,IF(AND((A:2="WOOD",C:2=6),PRICES!C:2etc etc etc

Maybe I totally of track here and there is an easier way.

Pleases help

Onesock