匹配

=INDEX(表!BU:BU,MATCH('表'!A,表!P:P,0)) =DATEDIF(H16,NOW(),"y")&"年"&D...查看全文

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8

匹配

=INDEX(表!BU:BU,MATCH('表'!A,表!P:P,0)) =DATEDIF(H16,NOW(),"y")&"年"&DATEDIF(H16,NOW(),"ym")&"月"&DATEDIF(H16,NOW(),"md")&"日"

写文章