在I1中输入或复制粘贴下列公式之一=VLOOKUP(--LEFT(A1,2),{30,"甲";32,"乙";34,"丙"},2)=LOOKUP(--LEFT(A1,2),{30,"甲";32,"乙";34,"丙"})=LOOKUP(--LEFT(A1,2),{30,32,34},{"甲","乙","丙"})下拉填充
