合併格 查找同姓名的客户号 (11026)

B2{=IFERROR(INDEX(F:F,SMALL(IF(LOOKUP("座",A$2:A2)=E$3:E$9,ROW($3:$9)),ROW(A1))),"")

另解{=IFERROR(INDEX(F:F,SMALL(IF(A$2=E$3:E$9,ROW($3:$9)),ROW(A1))),"")