MATCH function does not appear to work at all. Given the following data:
$7,109.19 | $867.19 | -$5,374.81 | -$11,616.81
=MATCH(MAX(FILTER(B122:U122, B122:U122 < 0)),B122:U122)
returns the error:
error: Did not find value -5374.810000000005
How can it not match a field for a value generated purely out of values that exist in the array?
All I really want to do is select a cell in a different row of the same column of the value that should be returned by that match call.
Thoughts?