If then statement with several variable.

[naredden]

I'm looking for an If then statement that would show the following:

IF F2= "High" and G2="High", then reference Worksheet1$H$4

Or IF F2= "High" and G2="Medium", then reference Worksheet1$I$4

Or IF F2= "High" and G2="Low", then reference Worksheet1$J$4

Or IF F2= "High" and G2="No", then reference Worksheet1$K$4

Or IF F2= "Medium" and G2="High", then reference Worksheet1$H$5

Or IF F2= "Medium" and G2="Medium", then reference Worksheet1$I$5

Or IF F2= "Medium" and G2="Low", then reference Worksheet1$J$5

Or IF F2= "Medium" and G2="No", then reference Worksheet1$K$5

Or IF F2= "Low" and G2="High", then reference Worksheet1$H$6

Or IF F2= "Low" and G2="Medium", then reference Worksheet1$I$6

Or IF F2= "Low" and G2="Low", then reference Worksheet1$J$6

Or IF F2= "Low" and G2="No", then reference Worksheet1$K$6

Or IF F2= "No" and G2="High", then reference Worksheet1$H$7

Or IF F2= "No" and G2="Medium", then reference Worksheet1$I$7

Or IF F2= "No" and G2="Low", then reference Worksheet1$J$7

Or IF F2= "No" and G2="No", then reference Worksheet1$K$7

This =IF(AND([@Probability]="High", [@Severity]="High"),Legend!H4," ")

Gives me the first equation, "High" + "High".  

Frustrated.

Thank you.

[#2]

Hi @naredden 

Instead of using multiple IF functions, you can use INDEX and MATCH as shown below

=INDEX(Sheet2!$H$4:$K$7,MATCH(Sheet1!$B2,Sheet2!$G$4:$G$7,0),MATCH(Sheet1!$A2,Sheet2!$H$3:$K$3,0))

I have attached the worksheet for easier referencing.

Cheers

[#3]

@wumolad 

Thank you so much. I was really racking my brain with that one. I am a novice at best with formulas. This worked perfectly.

Thank you.

[#4]

Hi @naredden 

Good to know it worked perfectly.

Please mark as the solution to close out the discussion.

Cheers