Compare two fields, different worksheet files

[JHL]

How can I find matches in two different worksheet files? I've tried:
IF=(sheet1!(cell)=sheet2!(cell),"ok","no") - but no success.
My formula is just an example. I know I left off the file reference in the
formula. The actual cells are numbers formatted as text.

Any help, suggestions are appreciated.
JHL

 

[Bill Kuunders]

=IF(A1=[Book1]Sheet1!$A$1,"ok","no")

enter this in book2

Regards
Bill K

 

[CLR]

Try something like this, modified to suit..........

=IF([Book1.xls]Sheet1!$A$3=[Book1.xls]Sheet1!$C$1,"Yes","NO")

Vaya con Dios,
Chuck, CABGx3