Try

=ADDRESS(9,MATCH(MAX(B9:AK9),B9:AK9)+1)

Mike

"Opal" wrote:

I have been searching for hours with no resolution...

I need to find the cell location, not the value, of the maximum value
in a range. I am using Excel 2003.

I have tried:

=MATCH(MAX(B9:AK9),B9:AK9)

and the result I get is 15
doesn't help me...the location I need is N9

can anyone help?