=IF(ISNA(AND(VLOOKUP(D68,wip!$C:$V,18,0),VLOOKUP(C68,wip!$E:$V,16,0))),0,IF(MID(C68,3,1)="2",VLOOKUP(C68,wip!$E:$V,16,0),VLOOKUP(D68,wip!$C:$V,18,
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/27 11:41:06
![=IF(ISNA(AND(VLOOKUP(D68,wip!$C:$V,18,0),VLOOKUP(C68,wip!$E:$V,16,0))),0,IF(MID(C68,3,1)=](/uploads/image/z/13415150-38-0.jpg?t=%3DIF%28ISNA%28AND%28VLOOKUP%28D68%2Cwip%21%24C%3A%24V%2C18%2C0%29%2CVLOOKUP%28C68%2Cwip%21%24E%3A%24V%2C16%2C0%29%29%29%2C0%2CIF%28MID%28C68%2C3%2C1%29%3D%222%22%2CVLOOKUP%28C68%2Cwip%21%24E%3A%24V%2C16%2C0%29%2CVLOOKUP%28D68%2Cwip%21%24C%3A%24V%2C18%2C)
=IF(ISNA(AND(VLOOKUP(D68,wip!$C:$V,18,0),VLOOKUP(C68,wip!$E:$V,16,0))),0,IF(MID(C68,3,1)="2",VLOOKUP(C68,wip!$E:$V,16,0),VLOOKUP(D68,wip!$C:$V,18,
=IF(ISNA(AND(VLOOKUP(D68,wip!$C:$V,18,0),VLOOKUP(C68,wip!$E:$V,16,0))),0,IF(MID(C68,3,1)="2",VLOOKUP(C68,wip!$E:$V,16,0),VLOOKUP(D68,wip!$C:$V,18,
=IF(ISNA(AND(VLOOKUP(D68,wip!$C:$V,18,0),VLOOKUP(C68,wip!$E:$V,16,0))),0,IF(MID(C68,3,1)="2",VLOOKUP(C68,wip!$E:$V,16,0),VLOOKUP(D68,wip!$C:$V,18,
and 是求并
isna跟iserror差不多.是判断出错与否,相当于否命题,如果A为真,isna(A)为假,如果A为#N/A,isna(A)为真.
mid是字符串函数,MID(C68,3,1)返回c68字符串中从第3个字符开始的长度为1的字符串,如果c68的字符串为12345,则返回3
个人觉得应该把 and内的vlookup换为match为好
主要意思是 如果两个有一个没有找到的话,就为0,如果两个都找到的话,并且C68字符串的第三个为2的话,返回VLOOKUP(C68,wip!$E:$V,16,0),否则返回VLOOKUP(D68,wip!$C:$V,18,0).