用VLOOKUP取同村名 (9752)

B2{=IFERROR(VLOOKUP(COUNTIF(A$2:A2,A2)&A2,IF({1,0},COUNTIF(OFFSET(E$2,,,ROW($1:$8)),E$2:E$9)&E$2:E$9,F$2:F$9),2,),"")