A列是范围 B列是对应数值 C列是输入数值 D列是输出数值就是想输入C 自动得出D 求高手支招
选择将A和B列整理下,再用公式=LOOKUP(C1,A1:A21,B1:B21)
=LOOKUP(C1,{0.28,0,0.35,0.39,0.45,0.48,0.58,0.68,0.78,1.21;1500,1200,1000,800,700,600,500,400,300,200})