Forum Discussion
Need for more than 64 levels of nested - Simplify formula
Nikoss I and re-attaching the sheet. I deleted the other formulas on that sheet in case there was some confusion. It works just fine for me. Maybe you could explain a little more what you mean by it giving the wrong results. Does it sometimes give correct results? Does it ever change? Can you give an example of a wrong result and what it gave and what you wanted it to give?
Hello, mtarler or who can reply...I have similar issue described above but I cannot solve...basically I wrote a beast function with more than 64 levels by using IF and AND but of course it does not work 😞 ...having a look at the attached, in a nutshell what I am trying to do is: IF A14=B1 AND A15=A2, give me B2...up to IF A14=M1 a AND A15=A11 give me M11 and so on for all the combinations on the rows and columns...is there a way to do that? Thanks
