Need help with IF statement

[zazybang]

Hey guys! So I wanted to use a INDEX-MATCH-MAX statement in order to find the highest number within a row then use INDEX to place the name linked to that number within that row. This worked well, but now I want to merge it with a IF statement and dont know how to. This is why I come to you, the experts of excel, seeking help! Formula: =INDEX('Officer Roster'!C5:C48,Match(MAX('Officer Roster'!S5:S48),'Officer Roster'!S5:S48,0))

 

[zazybang]

Oh i forgot to mention the purpose of merging it with an IF statement. What i wish to accomplish is that if the IF statement is false then the cell will say "-".

 

[JonXL]

What are you testing for in you IF statement?