匹配

=INDEX(表!BU:BU,MATCH('表'!A,表!P:P,0))

=DATEDIF(H16,NOW(),"y")&"年"&DATEDIF(H16,NOW(),"ym")&"月"&DATEDIF(H16,NOW(),"md")&"日"

转载于:https://blog.51cto.com/cuobiezi51cto/769509