Hi Jayden,
Thanks for using Syncfusion products.
We would like to let you know that our ejCalculate doesn’t provide support for VLOOKUP formula. Could you please let us know from where you notice that Calculate provided support in that formula and further this VLOOKUP formula in ejCalculate will be available only in any of our upcoming releases. After that, the Spreadsheet will provide support for that formula.
Regards,
Shanmugaraja K