How can find location of value in a square using excel

Question

I have tried to find the location of the max value written between B4 and F11 using:

 =MATCH(MAX(B4:F11),B4:F11,0) 

Returns n/a. Can someone please help me with this?

Answer 1

For the cell address:

=LET(ζ,B4:F11,BASE(MIN(IF(ζ=MAX(ζ),DECIMAL(ADDRESS(ROW(ζ),COLUMN(ζ),4),36))),36))