Show matching data

[Berry]

I have two columns of serial numbers, I need to identify any numbers common to both lists. Is there a function to do this?

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon

-----Original Message-----
I have two columns of serial numbers, I need to identify

any numbers common to both lists. Is there a function to
do this?

 

[xlbo]

Assuming you have one set of serial numbers in column A and another set in column B (both starting in row 2

In C2, ente
=if(not(isna(vlookup(A2,$B$2:$B$1000,1,false))),"IN BOTH LISTS",""
and copy dow

change 1000 to reflect the end row of the list in Col

Hope this help
Geoff

 

[Berry]

Thanks folks, much appreciated