IF(ISNA(VLOOKUP(C1,F:G,2,0)),"",VLOOKUP(C1,F:G,2,0)) 面的2,0

IF(ISNA(VLOOKUP(C1,F:G,2,0)),"",VLOOKUP(C1,F:G,2,0)) 面的2,0
IF(ISNA(VLOOKUP(C1,F:G,2,0)),"",VLOOKUP(C1,F:G,2,0)) 面的2,0

IF(ISNA(VLOOKUP(C1,F:G,2,0)),"",VLOOKUP(C1,F:G,2,0)) 面的2,0
F:G是查找区域,2是指输出第二列,0是指精确查找.
如果F:H,后面不是2,0,
是3,0则可以认为是查找C1在F列,如果找到后,把第三列的内容输出,也就是H列.