你的提问，我的做法是：在B2输入公式=IF(A2="","",LOOKUP($A2,{"A","B","C","D","E","F","G","H","I","G";1,2,3,4,5,6,7,8,9,10}))然后下拉填充即可。
B2输入公式=IF(A2="","",code(A2)-64)下拉公式
用INDEX配合MATCH即可
