直接在A4输入
=HLOOKUP(A3,{"a","b","c","d","e","f","g","h","i","j";9,8,7,6,5,4,3,2,1,0},2,0)
A4输入公式:
=(A3="a")*9+(A3="b")*8+(A3="c")*7+(A3="d")*6+(A3="e")*5+(A3="f")*4+(A3="g")*3+(A3="h")*2+(A3="i")*1+(A3="j")*0
第一行:a b c d e f g h i j
第二行:9 8 7 6 5 4 3 2 1 0
第三行:
A4输入:=HLOOKUP(A3,A1:J2,2,0)