EXCEL函数判断

 

=IF(C3="","",IF(IFERROR(VLOOKUP(C3,E:E,1,),"") <> "", "〇","×"))

=IF(IFERROR(VLOOKUP(E3,C:C,1,),"") <> "", "〇","×")

=IF(D3="×",IF(C3,"",""),"")

=IF(F3="×",E3,"")

 

posted @ 2022-04-12 08:56  奥兰王子  阅读(274)  评论(0)  编辑  收藏  举报