Hi all,

I am stuck at one point, please help me

I have 2 Excel sheets with same headers,
I need to do vlookup, I have huge date around 10000 in the excel.

I need to do vlookup from present date sheet to previous date sheet.

I need to do vlookup for the column
‘Ref number’

Please help me, it’s bit urgent

dt1.AsEnumerable.Where(Function(a) dt2.AsEnumerable.Any(Function(b) b("ColumnName").ToString.Equals(a("ColumnName").ToString))).CopyToDataTable

gives you the matched rows in both the tables based on your columnname

@Shiva_Nikhil I am getting error as The source contains no datarows

:ambulance: :sos: [FirstAid] Handling of The source contains no DataRows exception - News / Tutorials - UiPath Community Forum

Can anyone plz help me

Hi @hanviprebday,

Please try to use the attached solution. Make sure to create project on VB, Window & check the activities version too.
SourceToDestination.zip (165.9 KB)


Ok thank you will check