I must have the found the most complicated way to half do it.
Thanks Miguel that works a treat.

"Héctor Miguel" wrote:

hi, Rob !

I'd like to return a yes or no response.
at the moment only the YES is working.
Can anyone give me a tip?
Thanks
Rob

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

AFAIK, vlookup will try to find your lookup_value in the first column of your lookup_table
so, it doesn't make sense to incude whole columns by reference of the entire rows -?-

try with:

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

hth,
hector.