Hi,

Just do not understand what you are trying to do:

Why is there no column reference in your range_lookup I.e. how can it be
$1:$5000.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"Rob" wrote in message
...
Hello

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")