Sorry, posted in the wrong area. Have reposted in Worksheet Functions.
--
Jim T


"Jim Tibbetts" wrote:

Hello all,

The formula: =ADDRESS(2,MATCH(MAX(B2:AY2),A2:AY2,0),4) returns the cell
address (G2) of the largest number in B2:AY2 correctly.

The formula: =OFFSET(G2,-1,0) returns the name of the team in G1 that has
that highest total.

So why, when I replace the "G2" in the OFFSET formula with the ADDRESS
formula:
=OFFSET(ADDRESS(2,MATCH(MAX(B2:AY2),A2:AY2,0),4),-1,0) do I get an error
message?

Thanks for any ideas.
--
Jim T