Excel - compare 2 files [Closed]

Report
Posts
1
Registration date
Sunday July 29, 2012
Status
Member
Last seen
July 29, 2012
-
Hello,

here's my scenario:
I want to compare 2 columns from 2 different excel (2003) files which contain similar data, e.g.

file1
column1
1.5
2.1
8.2
.
.
.

file1
column2
1.9
9.1
8.9
.
.
.

file2
column1
1.7
2.3
8.6
.
.
.

file2
column2
6.5
3.1
1.2
.
.
.

IF column1 from file1 has the same number with column1 from file2 AND column2 from file1 has the same number with column2 from file2, THEN present (in a different spreadsheet and in a different column for each case) the output of column3 from file1.
Column3 from file1 has a different kind of data e.g. a name.

Thank you very much!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!