Here's my sheet that I'm using.Why is the match function not finding that zero? Basically, I have a set of numbers:7,244.5005,465.3476,923.0776,923.0774,084.3524,418.5203,685.9670,000.000I want a match function to find the 0,000.000, and my current function is=MATCH(0,C2:C9)But it just keeps returning #N/A, and says it can't find the value 0 in the range. Any idea why this might be?
Google sheets MATCH function not finding 0?
google spreadsheets
Because the range C2:C9 is not sorted, you need to override the default assumption of sorted by adding a third parameter 0, meaning unsorted, and exact match.Use =MATCH(0,Info!C2:C9,0).