I want use linq query for vlookup,basically i want to compare values from workbook1 column that is PO_No and in workbook2 also i have column PO No and beside that i have Today column so basically i want to paste the PO No values in Today column using Vlookup how can i achieve this?
Better write the vlookup formula using write cell and then use auto fill range to fill it till end…this way it would be quick as well if you need in excel directly
If you need in datatable then read both data and then use join datatable
