Compare two excel files and display true or false

I have two excel files with three columns each..I need to compare the two files with unique key which is the column 1 and display true for match and false for no match

A B C A B C
1 test 123 1 test1 123
2 junk 456 2 junk 456


I need

1 -False
2. true
Please help

Hi, Welcome to the Forum,

Could you post a workbook with a some sample data?

Are you looking at 2 workbooks
or 2 worksheets in the same workbook?

..

Thanks for the quick reply...I am looking to compare two workbooks and display result with true false in the third...I have attached the files to the first post

Ok Here you go, Use the button on the workbook attached to run your test.

Create a new folder on your desktop and name it "Your Folder"
This copy the 2 workbooks from your first post in that folder

open this script and press the test button. I placed a stop command in all you need to do is change the path from my desktop to yours.

Most likely you will only need to remove the RNG and put your name in.
an easy way to tell is open the folder you made above and look in the address bar and copy that line and replace it with what is in mine.

once you have your path in you can remove the stop and press F5

The script compares the first workbook to the second and the second workbook to the first.

It places the results in the compare workbook in col A and B and C and D

The reset just clears the data.

But it all depends on what your looking to compare,

Let me know if you need changes.

...

When your profile shows Excel 2003, it's hard for us to guess that you're using Excel 2007.

any one please help...I need this badly..

if column 1 from workbook 1 exist in any column in workbook2 then compare column b if it matches print true with column 1 and 2 else print false with column 1 and 2

if(worksheet1.column1=worksheet2.column1) then campare worksheet1.column2 with worksheet2.column2 if it matches display worsheet 1.column1,worksheet1,column2,true

Maybe ?

Please Login or Register  to view this content.