One way:

Assuming your lists are in columns A and B. Enter this formula in column C
and copy down to the end of the list in column B:

=IF(ISNUMBER(MATCH(B2,A$2:A$6,0)),"x","")

X = exists in column A

Biff

"ExcelInExcel" wrote in message
...
I have two lists list1 and list2

List 1 List 2
a b
b d
c e
d
e

Is there a way I can get the items in List2 that already exist in List 1
(b,d,e). It looks simple for the lists above but when I have lists with
100
or so items, it is not so easy.

thinking about it, will a vlookup do the job?