连续三个字符相同就匹配 (9704)

F2 一般公式=IFERROR(LOOKUP(1,0/MMULT(1-ISERR(0/(FIND(MID(A2&"@",COLUMN(A:I),3),"@"&C$2:C$9)>1)),ROW(1:9)^0),C$2:C$9),"")

A列固定前三字 可=IFERROR(VLOOKUP("*"&LEFT(A2,3)&"*",C:C,1,),"")