Comparing two columns in Excel not rowwise

I need ur help please.

I have an excel file that contains a 3 column (excel1) and another file (excel2) that contains 4 columns.
what i want is to compare a column in excel1 with another in excel2. if so, we display the 3 remaining column of the excel2 file.
N.B: the data in the column of the excel1 file are not in the same place as the column to be compared in the excel2 file.

Best regards,

1 Like

@beesheep @Manjuts90

@ifranity can u share sample excel files? and required output.

1 Like

Hi, thank you for the fast response :slight_smile:
please find attach the two excel files ExcelFile1.xlsx (8.0 KB)
ExcelFile2.xlsx (8.1 KB)
output the row in excel file2 if there is a match
N.B : we can found a lot of match too.

Thank you.

best regards,

we have to match col2 in excelfile1 with col1 in excel file2.

Go through the program it will compare both the column from different excel and will write it in excel 1 [ Status ]

Let me know if any other thing you want from this ExcelFile1.xlsx (8.5 KB)
ExcelFile2.xlsx (8.8 KB)
Main.xaml (11.0 KB)


oh thanks a lot @Rashmi,

I’ll test it and I’ll let you know

Best regards,

How can we display the row matched in a new sheet or excel file ? please

@ifranity u want write excelFile1 data or excelFile2 data to new sheet

I want to display row matched from the excelfile2 data

thanks :slight_smile:

@ifranity in new excel file right?

yes exactely :slight_smile: thanks

@ifranity i have made changes, to the workflow check below.

Main.xaml (13.3 KB)

1 Like

thank you very much buddy I’ll let you know :slight_smile:

1 Like

Awesome Job you guys rock… sorry didn´t reply early… keep it up!!!

1 Like

Hi @Manjuts90

that work thank you very much buddy :slight_smile: :slight_smile: :slight_smile:

Hi @Rashmi thank you that work :slight_smile: :slight_smile: :slight_smile:

1 Like

Rashmi’s example is very good! (I had a similar question too)

1 Like

Hi Rashmi, the project that you shared was amazing, but, how can I do if I want to export the “ExcelFile3.xlsx” with the different rows of each Excel file?
Because the code that you shared, saves only the same rows.

Best regards