Use MATCH maybe with OFFSET function to locate the MAX value in a row
Howevere be aware that if there is more than one MAX value in a row the MATCH will only find the first occurrence.