Hi All, I want to use VLookup functionality and for that i have two excel, From excel 1 i have one column called - “Service Account Number” and the same column i have in the second excel and based on that column i require column data of - “Cost Center”, “GL”, “Contact Name” from excel 2, How we can…

@Shubham_Jain2 , You can join the two data tables (from Excel 1 and Excel 2) based on the “Service Account Number” and retrieve the necessary columns (“Cost Center”, “GL”, “Contact Name”) from Excel 2. Here’s a sample approach using LINQ: Read both Excel files into DataTables using the Read Range …

VLookup Functionalit

Help Studio

Shubham_Jain2 (Shubham Jain) October 22, 2024, 1:06pm 4

Hi @ashokkarale ,
Thanks, it’s working.

1 Like

Topic		Replies	Views
How to perform Vlookup using Linq instead of Lookup data table Studio studio , question , activities_panel	1	187	January 18, 2024
How to make a vlookup using LINQ Studio studio , question , activities_panel	20	1283	December 19, 2023
Use vlookup with Linq and TWO DATATABLES Activities excel , activities , question	15	4644	November 17, 2021
How to perform a vlookup in 2 datatable Help datatable	9	9046	November 6, 2018
Vlookup using linq query Automation Hub excel , question , automation_hub	8	1218	March 16, 2023

VLookup Functionalit

Related topics