Sorry I misread your question, try this instead:

=CONCATENATE(OFFSET(A1,20,SUMPRODUCT(--(C22:AP34=C20)*COLUMN(C22:AP34))-1),SUMPRODUCT(--(C22:AP34=C20)*ROW(C22:AP34)))


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