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:
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.