前面字符相同 提取 (15038)

D2=LOOKUP(1,0/(LEFT(C2,{3,4,6})={"AAC","AAAA","AAAAAA"}),{"AAC","AAAA","AAAAAA"})

E2=LOOKUP(1,0/(FIND(G$2:G$4,C2)=1),G$2:G$4)