類似姓名 準確提取 (13861)

A1{=INDEX(D:D,RIGHT(MAX(IF(ISERR(FIND(LEFT(D$2:D$9,FIND(1,D$2:D$9)-1),B1)),9,LEN(LEFT(D$2:D$9,FIND(1,D$2:D$9)-1))/1%+ROW($2:$9))),2))&""