The specified formula cannot be entered because it uses more than 64 levels of nesting.

[Amr Eltaher]

My formula is too long and i cannot add more if functions in the formula cause it contains more than 64 levels of nesting.
This is the formula.

=IF(AND(C1=A15,C5=B37,C8=B44),D76,IF(AND(C1=A15,C5=B37,C8=B45),D77,IF(AND(C1=A15,C5=B37,C8=B46),D78,IF(AND(C1=A15,C5=B37,C8=B47),D79,IF(AND(C1=A15,C5=B37,C8=B48),D80,IF(AND(C1=A15,C5=B37,C8=B49),D81,IF(AND(C1=A15,C5=B37,C8=B50),D82,IF(AND(C1=A15,C5=B37,C8=B51),D83,IF(AND(C1=A15,C5=B37,C8=B52),D84,IF(AND(C1=A15,C5=B37,C8=B53),D85,IF(AND(C1=A15,C5=B37,C8=B54),D86,IF(AND(C1=A15,C5=B37,C8=B55),D87,IF(AND(C1=A15,C5=B34,C8=B44),E76,IF(AND(C1=A15,C5=B34,C8=B45),E77,IF(AND(C1=A15,C5=B34,C8=B46),E78,IF(AND(C1=A15,C5=B34,C8=B47),E79,IF(AND(C1=A15,C5=B34,C8=B48),E80,IF(AND(C1=A15,C5=B34,C8=B49),E81,IF(AND(C1=A15,C5=B34,C8=B50),E82,IF(AND(C1=A15,C5=B34,C8=B51),E83,IF(AND(C1=A15,C5=B34,C8=B52),E84,IF(AND(C1=A15,C5=B34,C8=B53),E85,IF(AND(C1=A15,C5=B34,C8=B54),E86,IF(AND(C1=A15,C5=B34,C8=B55),E87,IF(AND(C1=A15,C5=B35,C8=B44),F76,IF(AND(C1=A15,C5=B35,C8=B45),F77,IF(AND(C1=A15,C5=B35,C8=B46),F78,IF(AND(C1=A15,C5=B35,C8=B47),F79,IF(AND(C1=A15,C5=B35,C8=B48),F80,IF(AND(C1=A15,C5=B35,C8=B49),F81,IF(AND(C1=A15,C5=B35,C8=B50),F82,IF(AND(C1=A15,C5=B35,C8=B51),F83,IF(AND(C1=A15,C5=B35,C8=B52),F84,IF(AND(C1=A15,C5=B35,C8=B53),F85,IF(AND(C1=A15,C5=B35,C8=B54),F86,IF(AND(C1=A15,C5=B35,C8=B55),F87,IF(AND(C1=A15,C5=B36,C8=B44),G76,IF(AND(C1=A15,C5=B36,C8=B45),G77,IF(AND(C1=A15,C5=B36,C8=B46),G78,IF(AND(C1=A15,C5=B36,C8=B47),G79,IF(AND(C1=A15,C5=B36,C8=B48),G80,IF(AND(C1=A15,C5=B36,C8=B49),G81,IF(AND(C1=A15,C5=B36,C8=B50),G82,IF(AND(C1=A15,C5=B36,C8=B51),G83,IF(AND(C1=A15,C5=B36,C8=B52),G84,IF(AND(C1=A15,C5=B36,C8=B53),G85,IF(AND(C1=A15,C5=B36,C8=B54),G86,IF(AND(C1=A15,C5=B36,C8=B55),G87,IF(AND(C1=A15,C5=B38,C8=B44),I76,IF(AND(C1=A15,C5=B38,C8=B45),I77,IF(AND(C1=A15,C5=B38,C8=B46),I78,IF(AND(C1=A15,C5=B38,C8=B47),I79,IF(AND(C1=A15,C5=B38,C8=B48),I80,IF(AND(C1=A15,C5=B38,C8=B49),I81,IF(AND(C1=A15,C5=B38,C8=B50),I82,IF(AND(C1=A15,C5=B38,C8=B51),I83,IF(AND(C1=A15,C5=B38,C8=B52),I84,IF(AND(C1=A15,C5=B38,C8=B53),I85,IF(AND(C1=A15,C5=B38,C8=B54),I86,IF(AND(C1=A15,C5=B38,C8=B55),I87,IF(AND(C1=A15,C5=B39,C8=B44),J76,IF(AND(C1=A15,C5=B39,C8=B45),J77,IF(AND(C1=A15,C5=B39,C8=B46),J78,IF(AND(C1=A15,C5=B39,C8=B47),J79))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))))

Any help please

 

[jasonb75]

Your formula is mixed up and almost impossible to read, it would appear that your data is similarly organised.

This is best guess from what I can make out you are trying to do.

=IFERROR(IF(C1=A15,INDEX((E76:E87,F76:F87,G76:G87,D76:D87,I76:I87,J76:J87),MATCH(C8,B44:B55,0),1,MATCH(C5,B34:B39,0))),"")

 

[Amr Eltaher]

Super, this really worked. thank you genius

 

[jasonb75]

You're welcome.

I'm just curious why your results follow a pattern that is broken at one point,

C5 = B34, result in column E
C5 = B35, result in column F
C5 = B36, result in column G

Why C5 = B37, result in column D? Is this correct or an error? The rest of the data suggests that this should be result in column H, in which case the formula could be made even simpler

=IFERROR(IF(C1=A15,INDEX(E76:J87,MATCH(C8,B44:B55,0),MATCH(C5,B34:B39,0))),"")

 

[Amr Eltaher]

I adjusted the Excel sheet to follow the simpler formula .. Really appreciate your effort.