I have two data tables DT1 and DT2 now I need to compare row by row any one of the column from DT1 to third column of DT2 i.e “c” column (DT2 contains three columns like A,B,C) if i found match in column “C” I need to get the row value of column “A” in DT2 and need to update that row value in DT1 table in some column.

I think in my case this logic not gonna work because continuity of that, if I not found any one of row match in column “c” DT2 again I need to get another one of column data from DT1 need to compare with B column DT2 , match found then same get value from column A and pass to DT1 where we suppose to enter matches data.

excel 2 , I stored two excel data into two data tables DT1 and DT2, now i need to compare complete data one by one from one of the column of DT1 to “D” column of DT2 (we can find match anywhere in the column not row by row)once I found match then I need grab the value from column A in DT2 and need to store in DT1 table /// If not find the match again I need to go back to DT1 and get another column data of unmatched cell value and start looking in column “C” of DT2 if match find in anywhere of entire column grab corresponding column “A” value from DT2 and update in DT1…please help required thanks advance,