LinQ Query for VlookUp Need Help

Help Activities
, , , , ,
1

I have 2 Excels, in FilterStatementofAccount I have Column Ar Amount, and I have another Excel name with FilterOverallClaims, I need to do Vlookup to Ar Amount from FilterStatementofAccount.xlsx to FilterOverallClaims.xlsx in both files I have common value is Invoice, I tried Look up data Table it working but taking to much of time since i have 1 lakh records

Kindly help me on this. if there is no matching found then it should fill Empty.

FilteredStatementOfAccount.xlsx (9.4 KB)
FilteredOverAllClaims.xlsx (13.9 KB)

2

Hi @Ramesh_Kola1 ,

Refer this link it might be useful! If you not get solution let us know will do another video on it! We are here to help😊.
Link:- https://youtu.be/6TNassqRxw0?si=JAeeF5GrVW0E6lWF
Regards,
Techystack

3

Thank you!! it Worked

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.