Return a value if two conditions met

[BOYS82]

PDR rating	OP	VE	EP/DP	MP	PP
% Bonus payable
CBD	12.00%	10.00%	8.00%	4.00%	0.00%
CBM	9.00%	7.50%	6.00%	3.00%	0.00%
CDE / CDM	5.00%	4.00%	3.00%	1.00%	0.00%

<tbody>
</tbody>

I need to return a value if certain crietria is met i.e OP & CBD, however the cell i return is a drop down so the user can select the PDR rating, therefore they can choose if a CBD is a OP, VE, EP etc rating so a fixed formaula will not work and thats where i am getting stuck?
Please can anyone help me wit this?

 

[DRSteele]

Is this what you had in mind? Cells B8 and D8 are controlled by Data Validation: select the %Bonus and select the PDR rating and the formula will find the appropriate rate.

Excel 2012
	A	B	C	D	E	F
1		PDR rating
2	% Bonus payable	OP	VE	EP/DP	MP	PP
3	CBD	12%	10%	8%	4%	0%
4	CBM	9%	8%	6%	3%	0%
5	CDE / CDM	5%	4%	3%	1%	0%
6
7		% Bonus payable		PDR rating
8	choose:	CBD		OP
9	result:				12%
10
11	http://www.mrexcel.com/forum/excel-questions/856270-return-value-if-two-conditions-met.html
Sheet14

Cell Formulas
Range	Formula
E9	=INDEX($B$3:$F$5,MATCH($B$8,$A$3:$A$5,0),(MATCH($D$8,$B$2:$F$2,0)))

 

[BOYS82]

Is this what you had in mind? Cells B8 and D8 are controlled by Data Validation: select the %Bonus and select the PDR rating and the formula will find the appropriate rate.

Excel 2012

	A	B	C	D	E	F
1		PDR rating
2	% Bonus payable	OP	VE	EP/DP	MP	PP
3	CBD	12%	10%	8%	4%	0%
4	CBM	9%	8%	6%	3%	0%
5	CDE / CDM	5%	4%	3%	1%	0%
6
7		% Bonus payable		PDR rating
8	choose:	CBD		OP
9	result:				12%
10
11	http://www.mrexcel.com/forum/excel-questions/856270-return-value-if-two-conditions-met.html

<colgroup><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>

Sheet14​

Worksheet Formulas Cell Formula E9 =INDEX($B$3:$F$5,MATCH($B$8,$A$3:$A$5,0),(MATCH($D$8,$B$2:$F$2,0))) <thead> </thead><tbody> </tbody>

<tbody>
</tbody>

Yes this is exactly what im looking for thanks so much, although i keep getting a return value of #NA? Do you ahve any idea why this would be the case?

Many thanks