初步想到四种函数方法处理。
方法一、输入公式=MID("甲乙丙丁戊己庚辛壬癸",INT(RAND()*10+1),1)
方法二、输入公式=CHOOSE(INT(RAND()*10+1),"甲","乙","丙","丁","戊","己","庚","辛","壬","癸")
方法三、输入公式=LOOKUP(INT(RAND()*10+1),{1,2,3,4,5,6,7,8,9,10},{"甲","乙","丙","丁","戊","己","庚","辛","壬","癸"})
方法四、=VLOOKUP(INT(RAND()*10+1),{1,"甲";2,"乙";3,"丙";4,"丁";5,"戊";6,"己";7,"庚";8,"辛";9,"壬";10,"癸"},2,0)
选择输入一种公式后向下填充即可得到一列甲乙丙丁……的数据。
在sheet1的b2单元格输入以下公式，然后向下填充公式
=vlookup(a2,sheet2!a:b,2,0)
公式表示：在sheet2的a列精确匹配与a2单元格相同的单元格，并返回对应第2列（sheet2的b列）数据。
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024