Compare 2 excel columns if there is match and get the match items

What is the best way or how to compare 2 excel files column. I wanted to compare column from excel 1 and column from excel 2 and then get the match result if there is match. Is nested loops always a solution to this ? Any better implementation ? Help would be much appreaciated , Thank you.,

Excel 1


Excel 2

Btw sorry , what I mean is I want to compare excel 1 column 1 to excel 2 column 3. I wanted to check if there is equal or match and then get the matched result. Thanks

Hi @Jelrey,

Loop is the simplest way , if you don’t want to use loops you can consider using a linq query for performing the operation.