Vlookup table with multiple values from DataTable

[Supakinee_Navawong_na_ayu (Supakinee Navawong na ayudhya)]

Hi,

What can I do to compare record between 2 datatables with more than one columns?

I want to check both values Name+Dept from New_Dt in Old_Dt, If exists update status = Edit else status = Add.

How can I default in Vlookup activities?

[Sriganes96 (Sriganes Selvam)]

Check the below link for solutions

Compare two data tables in different excel files

Hi Guys, i have a two different excel sheets ,here i need to do, first take any row value from excel sheet 1 and search the value which we picked in excel1 in to another excel sheet . if value is there in excel 2, ok no issue …if value is not there we need to through exception. this is the scenario …please any one help me on this.