Hi,

assuming your data starts from A1,

=INDIRECT(ADDRESS(MATCH(MAXA(B1:B4),B1:B4,0),COLUM N()-1))

else if it starts from row n

=INDIRECT(n+ADDRESS(MATCH(MAXA(B1:B4),B1:B4,0),COL UMN()-1))

"patrickcairns" wrote:


Perhaps something like this is the adjacent column

=LOOKUP(MAXA(B1:B10),B1:B10,A1:A10)


--
patrickcairns
------------------------------------------------------------------------
patrickcairns's Profile: http://www.excelforum.com/member.php...o&userid=31790
View this thread: http://www.excelforum.com/showthread...hreadid=515615