Column K contains Vlookup function which will return ‘Y’ or ‘N’ depending upon the value in the C column. Even though the C7 and C9 contains the same value K7 gives value ‘Y’ and K9 gives value ‘N’ (which should be ‘Y’).

Data type of C7 and C9 is the same.

Actually, after the robot run, all the values in the column K becomes “N”, even though the output should be “Y”. Vlookup function is correct and when we double click on the C column values, we get the correct answer.

This happens when we write the data table to the excel.

Could anyone help on this ?