MATCH not Returning correct value

[szymagic]

Hello all, this is driving me absolutely mad, MATCH is returning the wrong value, for only this set of data.

0.59	30
0.37	35
1.31	55
			25	0
			30	0.59
			35	0.37
			40	0
			45	0
			50	0
			55	1.31
			60	0
			65	0
			70	0
				10

<tbody>
</tbody>

Where you see "10" at the bottom is the formula =MATCH(MAX(F5:F14),F5:F14) -------------[F5:F14 is the range including 0.59, 0.37 and 1.31]


The formulas in the F5:F14 are {=SUM(IF(($C$2:$C$4=E6),$B$2:$B$4,0))} ---------- E6 in this case is referencing "25" and that formula is dragged down through "70"


Clearly the max value is in position 7 not 10.


Thanks for any feedback!

 

[63falcondude]

Add a zero at the end of your match formula to specify the match type.

Formula would become =MATCH(MAX(F5:F14),F5:F14,0)

 

[szymagic]

Wow, am I foolish!?

Thanks, works perfect, I knew it had to be something simple I was overlooking!

 

[63falcondude]

Wow, am I foolish!?

Thanks, works perfect, I knew it had to be something simple I was overlooking!

Glad to help! Although it's optional, I always include the match type to avoid situations like this. For some reason, it chose to use 1 (Less than) instead of 0 (Exact match).