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:
What should be displayed in the cell, as shown below:
- Open up Google sheets
- Have a VLookup function in column B reference column A which also contains a formula
- Export the spreadsheet
- Import the google sheets file into Excellentable
- 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.