中文顏色取資料 (11066)

 

 D17:I22{=INDEX($C:$C,SMALL(IF((LOOKUP(1,0/FIND({"紅","黄","绿"},$C17),{1,2,3})=LOOKUP($D$4:$F$13,{0,60,81},{1,2,3}))*COUNTIF($C17,$D$3:$F$3&"*"),ROW($4:$13),99),COLUMN(A1)))&""