Would really appreciate any ideas...

I have a range of data A1:M20 containing a number of different percentages.
I want to look up the max and min and get it to report the corresponding name
in column N (the column to the right of the range).

The Max/Min can be in any column or row so the v look up needs to be dynamic
or be able to look up the max/min in a range...

please please help.....much apprecitaed