Excel automation to add matching values in column

[tejas.kotharkar]

I m having same columns (Material) in export 1 and results and i want to add the Document value of matching with material in results sheet.
I do not want to use for each loop as the data will be in million later as it will consume time in process.
Can you please help me with this?
Thanking you in advance!
Results.XLSX (484.7 KB)
Export1.XLSX (11.1 KB)

[Ajay_Mishra (Ajay Mahendra Mishra)]

Hey @tejas.kotharkar

I have solved your query,

LinQ:

dt_Output = (
From row In dt_Result
Join main In dt_Export
On row("Material").ToString Equals main("Material").ToString
Select dt_Output.Rows.Add(row("Material"),main("Document"))
	).CopyToDatatable

Screenshot for your reference:

Attaching .xaml for your reference:
Lookup_forum.xaml (9.6 KB)

Regards,
Ajay Mishra