Hi Leo,
Use the following code for the VLookup Function in XlsIO.
//Setting the VLOOKUP Formula.
sheet.Range["A28"].Formula="VLOOKUP(A12,A10:B26,2,FALSE)";
Here is the sample for your reference:
Vlookup.zip
Please let me if you need any further assistance.
BestRegards,
Bharath