Does the [ search_type ] difference in MATCH affect performance?
I am trying to consider why I would use 1 instead of 0, and I can only think that it must be a performance issue.
This assumes that search_type 1 uses divide and conquer, where as 0 searches linearly.
I have had situations were using 1 gets a bad result if the lookup range gets sorted, so I make sure I use 0 to mitigate that. And I want to make sure that I am not overlooking someone other downside to using 0.
Help Article Resources
Check out the Formula Handbook template!