Fix for nested VLOOKUP not working in Excellentable

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: 

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

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.