fill in a cell if two cells meet a criteria?

[JMITCH26]

If 2 Criteria is meet then Cell = that percentage Increase.

Example1
IF Cell A3= Hammer
IF Cell B3= Poor
Then Cell C3= 5.00%

Example2
IF Cell A4= Socket
IF Cell B4= Good
Then Cell C4= 10.00%

My Chart
B5 = Socket
E6 = Damaged F6 = 3.00%
E7 = Poor F7 = 4.00%
E8 = Fair F8 = 6.00%
E9 = Good F9 = 10.00%
E10 = Better F10 = 14.00%
E11 = Best F11 = 20.00%

B6 = Hammer
G26 = Damaged H26 = 2.00%
G27 = Poor H27 = 5.00%
G28 = Fair H28 = 6.00%
G29 = Good H29 = 11.00%
G30 = Better H30 = 15.00%
G31 = Best H31 = 20.00%

B7 = Wrench
K26 = Damaged L26 = 3.00%
K27 = Poor L27 = 4.00%
K28 = Fair L28 = 5.00%
K29 = Good L29 = 7.00%
K21 = Better L30 = 8.00%
K31 = Best L31 = 9.00%

 

[fhqwgads]

like this?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1
2
3	Hammer	Poor	5.00%
4	Wrench	Good	7.00%
5		Socket
6		Hammer			Damaged	3.00%	Damaged	2.00%			Damaged	3.00%
7		Wrench			Poor	4.00%	Poor	5.00%			Poor	4.00%
8					Fair	6.00%	Fair	6.00%			Fair	5.00%
9					Good	10.00%	Good	11.00%			Good	7.00%
10					Better	14.00%	Better	15.00%			Better	8.00%
11					Best	20.00%	Best	20.00%			Best	9.00%
Sheet31

Cell Formulas
Range	Formula
C3	=TEXT(IF(MATCH(A3,$B$5:$B$7,0)=1,VLOOKUP(B3,$E$6:$F$11,2,FALSE),IF(MATCH(A3,$B$5:$B$7,0)=2,VLOOKUP(B3,$G$6:$H$11,2,FALSE),IF(MATCH(A3,$B$5:$B$7,0)=3,VLOOKUP(B3,$K$6:$L$11,2,FALSE)))),"0.00%")
C4	=TEXT(IF(MATCH(A4,$B$5:$B$7,0)=1,VLOOKUP(B4,$E$6:$F$11,2,FALSE),IF(MATCH(A4,$B$5:$B$7,0)=2,VLOOKUP(B4,$G$6:$H$11,2,FALSE),IF(MATCH(A4,$B$5:$B$7,0)=3,VLOOKUP(B4,$K$6:$L$11,2,FALSE)))),"0.00%")

EDIT: formula was cut off a bit.
here is the formula in C3
=TEXT(IF(MATCH(A3,$B$5:$B$7,0)=1,VLOOKUP(B3,$E$6:$F$11,2,FALSE),IF(MATCH(A3,$B$5:$B$7,0)=2,VLOOKUP(B3,$G$6:$H$11,2,FALSE),IF(MATCH(A3,$B$5:$B$7,0)=3,VLOOKUP(B3,$K$6:$L$11,2,FALSE)))),"0.00%")

 

[JMITCH26]

This is working Thank you..... I do have a question when I have no data in cells A3 or B3 yet it gives me a #N/A is there a way to make this blank until data is entered? thank you for your help on this.

 

[fhqwgads]

this should work hopefully
=IF(OR(A3="",B3=""),"",TEXT(IF(MATCH(A3,$B$5:$B$7,0)=1,VLOOKUP(B3,$E$6:$F$11,2,FALSE),IF(MATCH(A3,$B$5:$B$7,0)=2,VLOOKUP(B3,$G$6:$H$11,2,FALSE),IF(MATCH(A3,$B$5:$B$7,0)=3,VLOOKUP(B3,$K$6:$L$11,2,FALSE),""))),"0.00%"))

 

[JMITCH26]

yes thats Perfect thanks