How to find entire data in one column to another two excel


Iterate through your first Excel using a For Each Row and use a if condition to check if the name from the current row is available in your second and third DTs (your second and third Excel) and update the status column of the current row accordingly.

Refer the below link to understand how to find if a value exists in a DT column.

1 Like