Problem 

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.  

Symptoms 

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 

Resolution 

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.