Excel Manipulations using LQuery

Help Studio
1

Team,
I need some help to optimize code using LQuery for lakhs of Record in Excel.
Sheet 1 consists below data in Datable -
image
Sheet 2 consists below data in another data table -
image

Expected Output as below -

  1. Each item of Sheet-1 colm-A, needs to compared with each item of clom-A of Sheet-2. If it matches then we need to extract Colm-C of Sheet 2 and write in Sheet 3
  2. Output is saved in Sheet-3

image

NOTE - Logic is implemented using for 2 for each loops which i want to optimize using LQuery. Any suggestions would be helpful.
Thanks

2

In general we can do with DataJoin (Activity or LINQ) or implement it as a custom Match/Lookup case (for getting back all matchers)

Any reasons why 9-FDMS2, 9-BYPS, 9-AFFN are not within the expected output sample, but a 9-FMB3?

3

In Sheet-3 Output Snapshot consider only 1st row as expected output.
Other rows has been modified.