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

Hi Team,

I am going to find entire data in one excel to another two excel and once data found any one excel or both excel will update the status in first excel

Ex:

Input:

Excel A Excel B Excel C
Name Name Name
XXX YYY DDD
YYY AAA YYY
ZZZ XXX ZZZ

Output:
Excel A
Name Status
XXX Found Excel B
YYY Found Excel B and Excel C
ZZZ Found Excel C

Please anyone help me out from this.

I have attached excel for yours Ref

Excel A.xlsx (9.5 KB)
Excel C.xlsx (8.6 KB)
Excel B.xlsx (8.6 KB)

Regards,
Raja G

@Raja.G

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