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?
1 Answers
usually, this is because you did not specify you want an exact match and your data is not sorted
Related