IF(ISNA(VLOOKUP...IF(ISNA(VLOOKUP(C1,F:G,2,0)),"",VLOOKUP(C1,F:G,2,0)) 求详细点的解释····最好能举例说明
来源:学生作业帮助网 编辑:作业帮 时间:2024/08/17 16:45:45
![IF(ISNA(VLOOKUP...IF(ISNA(VLOOKUP(C1,F:G,2,0)),](/uploads/image/z/5536314-18-4.jpg?t=IF%28ISNA%28VLOOKUP...IF%28ISNA%28VLOOKUP%28C1%2CF%3AG%2C2%2C0%29%29%2C%22%22%2CVLOOKUP%28C1%2CF%3AG%2C2%2C0%29%29+%E6%B1%82%E8%AF%A6%E7%BB%86%E7%82%B9%E7%9A%84%E8%A7%A3%E9%87%8A%C2%B7%C2%B7%C2%B7%C2%B7%E6%9C%80%E5%A5%BD%E8%83%BD%E4%B8%BE%E4%BE%8B%E8%AF%B4%E6%98%8E)
xRJQIc"EQ!9:cʐEhuf\ƿh9ShEӬ{}bx:Hmv3p8 $(Bh#D~?}tK,?e~YR>GvĺMh*vr
l<xhً֟E
:&I5_Q#1C$B[mkק6$g1IXEd7*HymJfMw4C,6%UeRa[]=vDT[X`b&EѥJB1µ*Ueؚ&R9}5] a#uh0
ph
BU,yΝ3U *dO3#{p'輤(B@ci?Oc
IF(ISNA(VLOOKUP...IF(ISNA(VLOOKUP(C1,F:G,2,0)),"",VLOOKUP(C1,F:G,2,0)) 求详细点的解释····最好能举例说明
IF(ISNA(VLOOKUP...
IF(ISNA(VLOOKUP(C1,F:G,2,0)),"",VLOOKUP(C1,F:G,2,0)) 求详细点的解释····最好能举例说明
IF(ISNA(VLOOKUP...IF(ISNA(VLOOKUP(C1,F:G,2,0)),"",VLOOKUP(C1,F:G,2,0)) 求详细点的解释····最好能举例说明
VLOOKUP(C1,F:G,2,0)这个运算明白了整个公式就好理解了.
这个运算就是查找C1的值在F列中,如果找到,把对应的G列的输出,
但是也有可能找不到,F列中没有C1单元格中的值,就会报错
ISNA就是查看是不是有错误,
所以这个公式可以简单写成 IF(ISNA(运算结果),"",运算结果)--- 运算结果是指VLOOKUP(C1,F:G,2,0)的运算结果.
IF(ISNA(运算结果),"",运算结果)
如果结果错误,就输出空白,也就是"",如果没有错误就把结果输出.