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.500 5,465.347 6,923.077 6,923.077 4,084.352 4,418.520 3,685.967 0,000.000
I want a match function to find the 0,000.000, and my current function is
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?