I have 3 lakh items in excel its taking more than one hour to run for vlookup.Is there any method for vlookup the data fastly
Hi,
Probably LINQ will help you. Can you share input sample and expected result as file? It’s no problem if dummy data.
Regards,
1 Like
For the huge data of excel, use the macros by using vb.net code. You can use the Invoke VBA Activity.
Hope it helps!!
Hi,
Can you also share expected output?
And also share how to input to book1 spcifically?
Regards,
Book1.xlsx (1.7 MB)
SampleCSVFile_2kb .xlsx (8.5 MB)
as odn refernce get the date and acknowlegement from sample to book1
I just sent only 2 col but there are 28 columns
how to vlookup fastly for this huge data
VLOOKUP is not working for both of the files, in those files there is a lot of duplicates.
If you are okay then I will write code to remove duplicates and do VLOOKUP.
Hope you understand!! @anjani_priya
the duplicates should not be removed
Hi,
Can you share how to handle same ODN but different Date and/or Acknowledgement?
Regards,
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.