Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

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

Answered
Request Demo
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

Comments

1 comment

Date Votes
  • Mike

    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

Please sign in to leave a comment.