I have 2 Excel files. 1st file contains column Full name (abcxyz). 2nd file contains column Name (abc, pqr, abc). I have to write Match using Linq query whenever “full name” contains Name. Please help how to write it.

Linq Query

KannanSuresh (Kannan Suresh) May 31, 2019, 2:01am 2

Topic		Replies	Views
Compare 2 different columns and the output in another column using linq query Activities excel , activities , studio , question	6	1479	May 16, 2023
Compare two Excel Sheets using Linq Studio	15	2513	June 1, 2020
Linq query to match columns of two excel files Activities excel , uiautomation , activities , studio , question	6	580	October 23, 2023
Compare two Excel file using Linq Query Studio studio , question , activities_panel	3	207	July 3, 2024
How to match the two columns value of one sheet with value of another sheet and if both value match then get third column value Activities excel , linq-query	7	544	August 2, 2023