地址 取对应关系 (11197)

C2=LOOKUP(9,0/MMULT(1-ISERR(0/(FIND(TRIM(MID(SUBSTITUTE(E$3:E$7,",",REPT(" ",99)),COLUMN(A:Z)*99-98,99)),"@"&A2)>1)),ROW(1:26)^0),D$3:D$7)