lookup vaules which are not exist in a table

  • Thread starter Thread starter ifulao
  • Start date Start date
I

ifulao

I have column A, B, C. I want to know what are the values in column A that not exist in column B&C.
Anyone can help this?
 
Hi,

Am Tue, 26 Nov 2013 06:39:42 -0800 (PST) schrieb (e-mail address removed):
I have column A, B, C. I want to know what are the values in column A that not exist in column B&C.
Click to expand...

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


Regards
Claus B.
 
Back
Top