IF条件和vlookup结合使用

残1梦

如何计算sheet2中T梁混凝土量，我的公式该怎么修改，帮帮忙，谢谢

残1梦

1. =IF(OR(VLOOKUP(C4,Sheet1!A:AF,5,FALSE)=1,VLOOKUP(C4,Sheet1!A:AF,5,FALSE)=5),IF(VLOOKUP(C4,Sheet1!A:AF,11,FALSE)=VLOOKUP(C4,Sheet1!A:AF,22,FALSE)="1",0.884*VLOOKUP(C4,Sheet1!A:AF,6,FALSE)+6.3403,IF(VLOOKUP(C4,Sheet1!A:AF,11,FALSE)=VLOOKUP(C4,Sheet1!A:AF,22,FALSE)="0",0.884*VLOOKUP(C4,Sheet1!A:AF,6,FALSE)+5.5119,0.884*VLOOKUP(C4,Sheet1!A:AF,6,FALSE)+5.9261)),IF(VLOOKUP(C4,Sheet1!A:AF,11,FALSE)=VLOOKUP(C4,Sheet1!A:AF,22,FALSE)=1,0.833*VLOOKUP(C4,Sheet1!A:AF,6,FALSE)+6.9772,IF(VLOOKUP(C4,Sheet1!A:AF,11,FALSE)=VLOOKUP(C4,Sheet1!A:AF,22,FALSE)=0,0.833*VLOOKUP(C4,Sheet1!A:AF,6,FALSE)+6.5213,0.833*VLOOKUP(C4,Sheet1!A:AF,6,FALSE)+6.7493)))

复制代码

hezudao_long

额，辣么长的公式，看着头晕，如果明天白天有时间，又没忘记，来帮你看看。   

lizhipei78

你这么长的公式看的头晕啊，如果真的是需要这么多IF的话，建议用IFS吧

另外你表达清楚你的想法吧

ohding

用数组函数吧

bpw0258

学习了，谢谢！