compare cells 2 different excel files

[phillypdh]

I could use a little guidance. I am trying to copmpare values of one cell to a value of another cell in another workbook.

 

[Robert Mika]

Coudl you give more information?

Do you just want to know if they are equal?

=A1=[Book2.xlsx]Sheet1!$A$1

 

[phillypdh]

actually i want to compare 2 cells in each workbook that has to match then be copied to another sheet.

 

[Robert Mika]

Look at INDEX/MATCH maybe....

 

[phillypdh]

Thanks I Think I can work with this info.

 

[Robert Mika]

You are welcome!