...知道一列数据中的其中的单元格包含的数值或者字母后,快速得出对应的...答:在B2中输入或复制粘贴下列公式 =IF(OR(MID(A2,4,1)={"1","2","3"}),LOOKUP(MID(A2,4,1),{"1","2","3"},{"单","双","三"}),IF(OR(MID(A2,3,1)={"C","Y"}),LOOKUP(MID(A2,3,1),{"C","Y"},{"无机石","石英"}),IF(OR(ISNUMBER(FIND("A",A2)),ISNUMBER...