Formula required to arrive at price

Hi

I was wondering if anyone could help me out with a formula for this situation please.

I have drawn up a table below:

	Column F	Column G	Column H	Column I	Column J
Row 4	Requirement 1	Requirement 2	QTY	PRICE	TOTAL
Row 5	X	Y	10	$-	$-

What I'm trying to achieve, is a price in 'I5' which is determined by the combination of requirements in 'F5' and 'G5'. 'F5' is limited to one of two options, which is selected from a drop down list on a separate sheet. 'G5' is one of four options at the moment also selected from a drop down list on a separate sheet. So that leaves me with eight possible outcomes.

Is this possible? If someone could help me out with this, it would be greatly appreciated.

Thank you in advance!