Skip to main content
Skip table of contents

Value of the formula cell cannot be computed

Symptoms

This issue arises when the VLOOKUP formula is used with reference data in a different tab. For example, the sheet containing the formula references data contained in another sheet named "Data":

CODE
=VLOOKUP(D2,Data!A:B,2,FALSE)

If you try to import an Excel file containing this sort of formula, the document will fail to render in Elements Spreadsheet, with "Value of the formula cell cannot be computed" errors in the console.

Resolution

Our implementation of VLOOKUP does not accept column ranges, so you will need to write =VLOOKUP(D2,Data!A1:B10000,2,FALSE) instead of =VLOOKUP(D2,Data!A:B,2,FALSE).

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.