=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,

=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).