Excel 2007 : Need help with isolating values in a long list

[lisamarie616]

I have two very long lists of data, let's call them List A and List B.

List A has about 500 values and List B has about 3,000 values. There are no duplicates in List A but there are duplicates in List B.

I want to isolate ALL the values in List B that match ANY value in List A. is there a way to do that??

[TMS]

One way:

=IF(COUNTIF($A:$A,$B2)>0,"Found","")

or you could use the =COUNTIF($A:$A,$B2)>0 as a Conditional Formatting condition.

Regards