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

Build Studio
, , ,
#1

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

column1

Excel 2

excel2
excel21174×574 90 KB

#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

comp
comp1112×722 110 KB

#3

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.