请问如何在excel中实现多重条件挑选？

=LOOKUP(A1,{0,1,2,3,4,5,6},{"A","B","C","D","E","F"}) 例如(0,5),(5,20),(20,40)等=LOOKUP(A1,{0,5,20,40,60,80},{"A","B","C","D","E","F"})

自已添加一下直到你说的20个条件