excel =IF(E16="",9,VLOOKUP(A16,DAT1,2,FALSE))

=VLOOKUP(A16,D:E,2,FALSE)数字函数公式不可用 =IF(A4="","",VLOOKUP(A4,MC,2,FALSE)) 这个EXCEL函数是什么意思? 如这公式中=IF($A16="","",VLOOKUP($A16,范围,9,0)),范围是怎样设定的 =IF(C3="","",VLOOKUP(C3,编码!$A$1:$B$10,2,FALSE)) 这个Excel表格公式是 excel匹配函数 =IF(ISNA(VLOOKUP(A2,Sheet1!A$1:AZ$9999,19,FALSE)), =IF(ISERROR(VLOOKUP(B23,'2'!B:E,4,FALSE)),"",VLOOKUP(B23,'2' =IF(ISERROR(VLOOKUP($B5,基本信息,2,FALSE)),"",VLOOKUP($B5,基本信息,2 =IF(ISERROR(VLOOKUP(E2,$A$2:$B$2500,3,FALSE)),0,VLOOKUP(E2,$ =IF(ISNA(VLOOKUP(A3,Sheet2!$A$1:$C$386,2,FALSE)),0,(VLOOKUP( =IF(ISNA(VLOOKUP($B7,'\\Sheet1'!$B:$L,2,FALSE)),0,VLOOKUP($B =VLOOKUP(A2,C:D,2,FALSE) =VLOOKUP(B5,gz,2,FALSE)