Below is a table that I am trying to reference using a formula. I tried to use the formula below, but you can only nest 7 functions. So what is the best way to do the formula below for 20 nested functions? I made a truth table below, but I'm not sure how to use it.

=IF(AND(I3="A",G3="A"),"correct",IF(AND(I3="A",G3="B"),"correct",IF(AND(I3="A",G3="C"),"false blue",IF(AND(I3="A",G3="D"),"false blue",IF(AND(I3="B",G3="A"),"correct",IF(AND(I3="B",G3="B"),"correct correct",IF(AND(I3="B",G3="C"),"correct","false")))))))

How can I reference the table below to display a value in column C when given the combination of A and B? I also want the result to say "false" if none of the 'if/ands' are true.

I can send file if needed. Please advise. Thanks in advance. Matthew

Col A Col B Col C

Row1 Source Response Result

Row2 A A Correct

Row3 A B Correct

Row4 A C False Blue

Row5 A D False Blue

Row6 A E Correct

Row7 B A Correct

Row8 B B Correct

Row9 B C False Blue

Row10 B D False Blue

Row11 B E Correct

Row12 C A Missed

Row13 C B Missed

Row14 C C Correct

Row15 C D False Blue

Row16 C E False Red

Row17 D A Missed

Row18 D B Missed

Row19 D C Missed

Row20 D D Correct

Row21 D E False Red