You could try something like this:

=IF(ISERROR(VLOOKUP(D1,A:A;1,0)),"Not found","")

Best.
http://www.exciter.gr
Custom Excel Applications and Functions!


On Nov 3, 12:13 am, Edward wrote:
Hi everybody !
Is there a a function in Excel that does something opposite to Vlookup. I
have a table that I want to compare with a data set in a column and find the
items that are not matching with those data.
--
Best regards,
Edward