Next to either list put in the formula

=if(Countif(Sheet2!$A$1:$A$15000,A1)0,A1,"")

then drag fill down alongside list (in the example, the list of 500 ID's).

--
Regards,
Tom Ogilvy

"nikf" wrote in message
om...
Hi,
I have two lists, consisting of customer ids in the form
00-00-00 ( using custom format). The first list consists
of 15,000 ids and the second one contains 500 id's. I would
like to create a third column that would consist of id's that
are in both lists.
Any help would be greatly appreciated, nikf