请教高手!!
现在我对“型号”单元格和“类型”单元格,都作了有效性设置,然后想在价格单元格中显示“型号”和“类型”单元格中对应的数值。一直本想用Vlookup公式( VLOOKUP(H8,B1:E28,MATCH(I8,B1:E1,0),0) )对价格单元格引入,但就是显示不了。特请指导,谢谢!!
型号 | 不锈钢 | 镜面 | 镜蚀刻 | 钛蚀刻 | | | | | | | | | LTK400 | 0.12 | 0.17 | 0.22 | 0.27 | | | | | | | | | LTK450 | 0.12 | 0.17 | 0.22 | 0.27 | | | | | | | | | LTK630 | 0.12 | 0.17 | 0.22 | 0.27 | | | | | | | | | LTK800 | 0.12 | 0.17 | 0.22 | 0.27 | | | | | | | | | LTK1000 | 0.12 | 0.17 | 0.22 | 0.27 | | | | | | | | | LTK1050 | 0.12 | 0.17 | 0.22 | 0.27 | | | 型号 | 类型 | 价格 | | | | LTK1350 | 0.15 | 0.25 | 0.34 | 0.4 | | | LTK630 | 镜面 | #N/A | | | | LTK1600 | 0.15 | 0.25 | 0.34 | 0.4 | | | | | | | | | LTK2000 | 0.15 | 0.25 | 0.34 | 0.4 | | | | | VLOOKUP(H8,B1:E28,MATCH(I8,B1:E1,0),0) | LTH1000 | 0.25 | | | | | | | | | | | | LTH1500 | 0.25 | | | | | | | | | | | | LTH2000 | 0.25 | | | | | | | | | | | | LTH3000 | 0.25 | | | | | | | | | | | | LTH5000 | 0.4 | | | | | | | | | | | | LTH8000 | 0.5 | | | | | | | | | | | | LTHX1000 | 0.25 | | | | | | | | | | | | LTHX1600 | 0.25 | | | | | | | | | | | | LTHX1500 | 0.25 | | | | | | | | | | | | LTHX2000 | 0.25 | | | | | | | | | | | | LTHX3000 | 0.25 | | | | | | | | | | | | LTHX4000 | 0.5 | | | | | | | | | | | | LTHX5000 | 0.5 | | | | | | | | | | | | LTQ3000 | 0.5 | | | | | | | | | | | | LTQ5000 | 0.5 | | | | | | | | | | | | LTQX3000 | 0.5 | | | | | | | | | | | | LTQX4000 | 0.5 | | | | | | | | | | | | LTQX5000 | 0.5 | | | | | | | | | | | |
|