就是如果A1是一个值,那么B1是另一个值,求大神帮助
可以LOOKUP这个函数,举个例子:
图中公式:=LOOKUP(A1,{1,2,3,4,5,6,7,8,9},{"A","B","C","D","E","F","G","H","I"})