Let the largest range seen in a range, in my formula

[grid]

Hello,

=INDEX(A3:Y3,LOOKUP(MATCH(LARGE((G36,O36,W36,AE36),1),A36:AE36,0),{1,9,17,25}))

That will return the day of the week that is in A3 I3 Q3 or Y3. Depending on the highest number on G36 O36 W36 or AE36.

This works correctly.


Now I want the highest number back again. This time I want to add the values range between (G33:G36,O33:O36,W33:W36,AE33:AE36)

I think it might be something like:

=INDEX(A3:Y3,LOOKUP(MATCH(LARGE((G33:G36,O33:O36,W33:W36,AE33:AE36),1),A36:AE36,0),{1,9,17,25}))

Although that did not work. I've posted an example.


Best regards,

grid