把括号替换为B列最长字符的词

原贴地址：

http://www./bbs/forum.php?mod=viewthread&tid=654&extra=

要求：

括号中填写Ｃ列中对应的最长的字符串

=SUBSTITUTE(D4,"（）",INDIRECT("c"&RIGHT(MAX((LOOKUP(ROW($4:$19),ROW($4:$19)/($A$4:$A$19<>""),$A$4:$A$19)=LEFT(B4))*LEN($C$4:$C$19)*100+ROW($4:$19)),2)))