How to compare column values from two different tables and if they match then paste the value present in the first excel sheet into another

[ronanpeter]

This should give you what you need

Write to a Particular Cell if Value is a match

So if you have your DataTable of ServiceIDs/IDs taken from the XML data it should look something like this: ID ServiceID 16 175 22 190 So you want to essentially do a vlookup between the two datatables. There are a number of ways to achieve this and you should monitor performance if your dataset is large. However, for me, this is the easiest. Just read in both datasets and use the Lookup DataTable Activity - The CSV datatable lookups up the XML datatable to return a ServiceID, if…