Excel三年后日期计算、Excel自动匹配数据

1、=IF(Z3="","",IF(Z3="长期","2099/12/31",IF(ISERROR(EDATE(X3,IF(Z3="一年",12,IF(Z3="三年",36,IF(Z3="长期","2099/12/31"))))),"",VALUE(EDATE(X3,IF(Z3="一年",12,IF(Z3="三年",36,"")))))))

（选中数据表后按F4）

2、=IF(ISERROR(VLOOKUP(AD3,Sheet2!$A$2:$B$5,2,FALSE)),"",VLOOKUP(AD3,Sheet2!$A$2:$B$5,2,FALSE))