[练习题]第4讲练习-vlookup1

xjj19781125

[em01]

mn860429

<br/>[em01]

yxdream

<p>单价：=VLOOKUP(A12,$A$5:$B$7,2,0)&nbsp; 或者&nbsp; =INDEX($B$5:$B$7,MATCH(A22,$A$5:$A$7,))</p><p>折扣：=VLOOKUP(B12,$D$5:$G$7,MATCH(A12,$D$4:$G$4,0),1)&nbsp; 或者&nbsp; </p><p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =INDEX($E$5:$G$7,MATCH(B22,$D$5:$D$7,1),MATCH(A22,$E$4:$G$4,0))</p><p>总计：=B12*C12*(1-D12)</p>

maodaojin6

[em01][em01]

strive52

谢谢老师<br/>,学习了!

strive52

<p>折扣：=INDEX($E$5:$G$7,MATCH(B22,$D$5:$D$7,1),MATCH(A22,$E$4:$G$4,0))</p><p>MATCH(B22,$D$5:$D$7,1)</p><p>MATCH(A22,$E$4:$G$4,0)</p><p>请问这两个公式中后面的1和0是什么意思了?</p><p>谢谢!</p><p>还有$D$5和$D5有什么区别了</p><p>谢谢!</p>

xuexiwawa

<p>认真学习努力提高</p>

雾山剑侠

<p>学习下</p><p></p>

szyygb

<p>好好学习</p><p>天天向上</p>

dreampool

<p>

游客，如果您要查看本帖隐藏内容请回复

<br/></p>