當前位置:成語大全網 - 新華字典 - Excel裏面a列輸入6,b列自動生成7類似這樣的,這怎麽弄啊大神們

Excel裏面a列輸入6,b列自動生成7類似這樣的,這怎麽弄啊大神們

在B2單元格輸入公式:

=IF(A2="","",CHOOSE(A2,"壹類","二類","三類","四類","五類","六類","七類"))

復制並下拉,之後,即可在A2單元格輸入相應的數字代碼,對應B列就自動顯示出類別了