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.
Am I doing something wrong?
The formula is: