判斷 单双国股 (11253)

D2=CHOOSE(SUM(MMULT(1-ISERR(FIND(G$2:G$16,A2:B2)),{1;2}))+1,"其他","单国股","双国股","双国股")

另解=LOOKUP(SUM(MMULT(1-ISERR(FIND(G$2:G$16,A2:B2)),{1;2})),{0,1,2},{"其他","单国股","双国股"})