I am using the find formula to get a row number in another table. No issues there. However, when there is no match, I am getting a “-1” value, instead of an error or null.
This then creates other errors as i’m using the find formula with some other math operations, and since -1 is a number I am getting values when I should be getting errors.
I actually was able to solve this by having smaller tables + a lookup formula. That does give an error when it does not find a value, so I managed to have a smaller formula.