I am using a rather simple match function, yet I cannot seem to understand why is it returning the wrong row number. You can see in the screenshot that the row is 111, yet match returns 113.

Any ideas?

Screenshot

CodePudding user response：

usually, this is because you did not specify you want an exact match and your data is not sorted