EXCEL对应取值范围所对应的值（最好是用两张表连接做的方法）SHEET1的内容0.095mm≤H≤0.12mm 36.7元/吨 0.12mm＜H≤0.15mm 32.2元/吨 0.15mm＜H≤0.2mm 30.5元/吨 0.2mm＜H≤0.26mm 26.2元/吨 0.26mm＜H≤0.35mm 22.8

来源：学生作业帮助网编辑：作业帮时间：2024/04/29 09:15:43

EXCEL对应取值范围所对应的值（最好是用两张表连接做的方法）SHEET1的内容0.095mm≤H≤0.12mm 36.7元/吨 0.12mm＜H≤0.15mm 32.2元/吨 0.15mm＜H≤0.2mm 30.5元/吨 0.2mm＜H≤0.26mm 26.2元/吨 0.26mm＜H≤0.35mm 22.8
EXCEL对应取值范围所对应的值（最好是用两张表连接做的方法）
SHEET1的内容
0.095mm≤H≤0.12mm 36.7元/吨
0.12mm＜H≤0.15mm 32.2元/吨
0.15mm＜H≤0.2mm 30.5元/吨
0.2mm＜H≤0.26mm 26.2元/吨
0.26mm＜H≤0.35mm 22.8元/吨
0.35mm＜H≤0.46mm 20元/吨
0.46mm＜H≤0.58mm 17.8元/吨
0.58mm＜H≤0.75mm 14.6元/吨
0.75mm＜H≤1.0mm 11.8元/吨
1.0mm＜H≤1.45mm 10元/吨
1.45mm＜H≤2.0mm 7.1元/吨
2.0mm＜H≤2.8mm 4.8元/吨
2.8mm＜H≤4.0mm 3.9元/吨
4.0mm＜H≤5.0mm 1.9元/吨
5.0mm＜H≤7mm 1元/吨
现在表2中是A列中是厚度H值,B列中是价格,现在如何用快捷的方法求B列中的价格
A列 B列
H 价格
7
0.55
1.25
1.9
0.83
7

EXCEL对应取值范围所对应的值（最好是用两张表连接做的方法）SHEET1的内容0.095mm≤H≤0.12mm 36.7元/吨 0.12mm＜H≤0.15mm 32.2元/吨 0.15mm＜H≤0.2mm 30.5元/吨 0.2mm＜H≤0.26mm 26.2元/吨 0.26mm＜H≤0.35mm 22.8
两张表链接不会做,只会一张表中的查找,用函数LOOKUP ,
=LOOKUP(A18,{0.095,0.12,0.15,0.2,0.26,0.35,0.46,0.58,0.75,1,1.45,2,2.8,4,5,7},{"36.7元/吨","32.2元/吨","30.5元/吨","26.2元/吨","22.8元/吨","20元/吨","17.8元/吨","14.6元/吨","11.8元/吨","10元/吨","7.1元/吨","4.8元/吨","3.9元/吨","1.9元/吨","1元/吨"})
假设所要查找的厚度数值在 A18 , 则在其右侧一格内填写以上公式