Vlookup not working with StudioX

I encounter an issue with the Vlookup function in StudioX it doesn’t work and I can’t find the problem.
I did a very simple excel file to test it :
In cell B11 I typed the formula and it works fine but when I tried it into StudioX and ask to save the value in cell B12 it doesn’t work. Here are my settings in StudioX: and the excel file:

Thank you for your help!


In Excel, column A contains numbers (they are right aligned), so when you configure the VLookup activity in StudioX, please make sure you set the “Value to lookup” as a number, not as text, otherwise it will not able to compare correctly and find the value:

it works, thank you very much for your help!