Hi,
If I understand you correctly a single row will only contain one entry
and you want to match that entry with the account number from the
header row. if so then try this:

=INDEX($G$6:$O$6,MATCH(IF(SUM(G7:O7)=0,"*",SUM(G7: O7)),G7:O7,0))

as you can see, it is a bit crude maybe one of the MVP's out there as
something better.

HTH
JG


--
pinmaster
------------------------------------------------------------------------
pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
View this thread: http://www.excelforum.com/showthread...hreadid=493117