Skip to main content

Fix for nested VLOOKUP not working in Excellentable


The Vlookup function was not working in Excellentable as it is in Google sheets. This presented as an issue in case the user has to import a file from google sheets with the function.  


The cells are reflecting an error returned, as shown below: 

Capture 2019-07-23 at 20.10.00.png

What should be displayed in the cell, as shown below: 

Capture 2019-07-23 at 20.06.23.png

Step-by-step guide 

  1. Open up Google sheets 
  2. Have a VLookup function in column B reference column A which also contains a formula   
  3. Export the spreadsheet 
  4. Import the google sheets file into Excellentable 
  5. Check the cells filled with the VLookup function 

Expected: The file should be imported with the cell outcome with the VLOOKUP function returning the correct output  

Actual: The cells with the VLOOKUP function are returning #N/A 


The fix was included when we released version 4.0 to the marketplace. The fix can be found in any of the latest releases too. 

JavaScript errors detected

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

If this problem persists, please contact our support.