Try this:

=CONCATENATE(IF(SUMPRODUCT(--(C22:AP34=C20)*COLUMN(C22:AP34))<=26,CHAR(SUMPRODU CT(--(C22:AP34=C20)*COLUMN(C22:AP34))+64),"A"&CHAR(SUMP RODUCT(--(C22:AP34=C20)*COLUMN(C22:AP34))+64-26)),SUMPRODUCT(--(C22:AP34=C20)*ROW(C22:AP34)))


Hope it helps.


--
Morrigan
------------------------------------------------------------------------
Morrigan's Profile: http://www.excelforum.com/member.php...fo&userid=7094
View this thread: http://www.excelforum.com/showthread...hreadid=397291