Fix Incorrect Argument Set when Matching Max Values
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.
Help Article Resources
Check out the Formula Handbook template!