Compare two fields, different worksheet files

  • Thread starter Thread starter JHL
  • Start date Start date
J

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
 
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
 
Back
Top