Comparing two columns in Excel not rowwise

Help
, , ,
1

Hello,
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
2

@beesheep @Manjuts90

3

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

1 Like
4

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,

5

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

6

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)

4 Likes
7

oh thanks a lot @Rashmi,

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

Best regards,

8

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

9

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

10

I want to display row matched from the excelfile2 data

thanks :slight_smile:

11

@ifranity in new excel file right?

12

yes exactely :slight_smile: thanks

13

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

Main.xaml (13.3 KB)

1 Like
14

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

1 Like
15

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

1 Like
16

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
17

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

1 Like
18

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