DT not appended in Excel that has VLOOKUP

I have a DT that I append in an excel worksheet, it appends earlier when I didn’t add a Column that has a VLOOKUP, after adding the column that has a VLOOKUP, my DT doesn’t seems to be appended.

@wdescalsota,

kindly try to explain with sample input and output data table, it will be helpful for more understand.

Thanks,
Rajkumar