Wouldn't you need the full path if the file is closed?

Pete

On Sep 17, 7:06*pm, "T. Valko" wrote:
Note that COUNTIF requires the source file be open. An alternative that
works whether the source file is open or closed:

=IF(COUNT(MATCH(A6,'[Catalogue Robs Test Stock
Range.xls]Catalogue'!$A$1:$A$5000,0)),"YES,"NO")

--
Biff
Microsoft Excel MVP