|
自 2021 年 1 月起，经典文件类型不再可用。您可以转换经典文件或下载 PDF 文件。了解更多

When would a vlookup function in Spreadsheets return "null"?

已回答
申请演示
I'm trying to debug a formula (cross sheet, same file) that should be returning a date but it keeps giving me "null" in the target cell.  Same behavior with =match
-1

评论

1 条评论

日期 投票数
  • Mike Davis

    Hi Matthew!

    Regarding your NULL issue, that is certainly weird. In Wdesk, you can trying changing the format of the cells in question to Date to see if that resolves the null issue.

    0

请先登录再写评论。