Comparing two lists

[srkj]

Hello:

I am looking for some guidance here

I have one column/list 1 as follows in a worksheet (this list may have duplicates)

A
A
B
C
A
B

I have another column/list 2 as follows in another worksheet (this list will not have duplicates)

A
B
C
D
E

What I am trying to do is to compare / intersect these two lists and come back with an answer

D
E

Basically, I am trying to find the elements in List 2 which are NOT appearing at all in List 1.

I appreciate any pointers / guidance.

thanks
srkj

 

[JoeMo]

Here's an example where List 1 (not shown) is on sheet1 and list 2 is on sheet 2. Copy the formula in sheet2 cell B2 down to cover the entire content of list 2, and change the cell references in sheet 1 to cover the entire content of list 1.

Excel Workbook
	A	B
1	List 2
2	D550
3	Tom	NoMatch
4	447u
5	T09X
6	****	NoMatch
7	8tl7
8	hk97
9	rUlw
10	2YbC
11	Bm95
12	Harry	NoMatch
13	IDo1
14	vCZ3
15	4maY
16	h4YA
17	af5F
Sheet2

 

[srkj]

Thank you, JoeMo

=IF(ISNA(MATCH(A2,Tasks!$A:$A,0)),"AVAILABLE","")

It just solved the problem elegantly.