Thread: lookup vaules which are not exist in a table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Claus Busch Claus Busch is offline
external usenet poster
  
Posts: 3,872
Default lookup vaules which are not exist in a table
Hi,

Am Tue, 26 Nov 2013 06:39:42 -0800 (PST) schrieb :

I have column A, B, C. I want to know what are the values in column A that not exist in column B&C.

in D1:
=IF(COUNTIF($B$1:$C$100,A1)=0,"no match","match")
and copy down


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
Reply With QuoteReply With Quote