Formula or Macro to return true value if multiple criteria met

[Profi10]

Hi Excels,

does anyone have a formula or macro to return a true value if multiple criteria are met, or in this case 2 out of 25 possible matchups.

I have tried the following but it keeps breaking the more criteria I add:

=IF(OR(AND(B2=N6, E2=O6), AND(B2=N6, E2=O5)), "Low", "N/A")(OR(AND(B2=N5, E2=O6), AND(B2=N5, E2=O5)), "Medium", "N/A")

The aim is to return a low, medium or high value if for example criteria "insignificant" in row B2 is matched up with criteria "rare" in row E2, or if criteria "insignificant" in row B2 is matched up with criteria "even chance" in row E2.

Any ideas?

Thanks for your help

 

[earthworm]

share sample data please

 

[Profi10]

Not sure how to post the spreadsheet, however this is an image of the sheet I am working on where if value from column A is combined with a value in column B it returns a rating of either low, medium or high in column C

 

[earthworm]

T

Not sure how to post the spreadsheet, however this is an image of the sheet I am working on where if value from column A is combined with a value in column B it returns a rating of either low, medium or high in column C

Try now

Book1
	A	B	C	D	E	F
1	Consequence	LikeliHood	Risk Rating - Low , Medium Or High		Legend
2	Insignificant	Rare	Low		InsignificantRare	Low
3	Very High	Likely	High		VeryHighLikely	High
4	Insignificant	Unlikely	Low		InsignificantUnlikely	Low
5	Major	Even Change	Medium		MajorEvenChange	Medium
Sheet1

Cell Formulas
Range	Formula
C2:C5	C2	=VLOOKUP(SUBSTITUTE(A2&B2," ",""),$E$2:$F$5,2,0)

 

[Profi10]

Mate this works great, thank you. Much appreciated