lookup vaules which are not exist in a table

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?
 
C

Claus Busch

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Adding sequence numbers to paragraphs 0
Adding a word to a numerical field 0
Setting column width in a table with a macro is not working 0
Incorporating the User Profile location into a document template path 1
Quick Parts / SharePoint Library Update 0
Extracting a cell value 2

Top