Vlookup1

Help Activities
1

Hi all,
I have a excel with 2 sheets, one sheet is current date and other sheet is old15days date.

There is a column by name Reference Number in both the sheets.

I need to do vlookup from current date reference number to old15days date reference number.

How to do this. Can you please help me.

2

@hanviprebday

dt1.Asenumerable.where(function(x) dt2.Asenumerable.any(function(r) r(“Supplier”).tostring.trim.equals(x(“Vendor Number”).tostring.trim)).copytodatatable

you can refer this

or you can provide sample input and expected output