more than 7 nested IF(AND) statements in formula - VBA? **NEWBIE**
Hello all -
I see that I have exceeded the limit of nested IF statements that Excel
allows.
I have read mulitudes of previous posts trying to the answer I need. I
can't find anything for statements with an IF(AND) function however. I
have read about VLOOKUPS and VBA codes, but can't figure out the right
tweak to make them work.
Here is the original formula that I wanted to work:
=IF(AND(M19=G17,J14J17),J17,(IF(AND(M19=G18,J14J 18),J18,(IF(AND(M19=G19,J14J19),J19,(IF(AND(M19=G 20,J14J20),J20,(IF(AND(M19=G21,J14J21),J21,(IF(A ND(M19=G22,J14J22),J22,(IF(AND(M19=G23,J14J23),J 23,(IF(AND(M19=G24,J14J24),J24,(IF(AND(M19=G25,J1 4J25),J25,J14)))))))))))))))))
Can anyone please assist in some VBA code or another way to get this
formula to work?
Thanks for your help!
Dan
|