Fix Incorrect Argument Set when Matching Max Values

Alex Folck

Hi! I'm trying to return a number value from my "Score" column in my sheet summary. The Score I want is whichever one has the latest date in the "Score Date" column. To accomplish this I'm trying to use the following formula:

=INDEX(Score:Score, MATCH(MAX([Score Date]:[Score Date])))

I'm getting an incorrect argument set error and I'm hoping someone can spot where I went wrong because I'm fairly new to formulas and am not sure where my mistake is.

Thank you!

Alex Folck

Figured it out, I needed to specify a range for the MATCH. Correct formula was:

=INDEX(Score:Score, MATCH(MAX([Score Date]:[Score Date]), [Score Date]:[Score Date]))

Woohoo!

Alex Folck

Figured it out, I needed to specify a range for the MATCH. Correct formula was:

=INDEX(Score:Score, MATCH(MAX([Score Date]:[Score Date]), [Score Date]:[Score Date]))

Woohoo!