Compare data in 2 worksheets
 

I have two worksheets of data. Columns A contain the same data in each
workbook (ID #'s). I need to find out if the data in Worksheet1 Column A is
in Worksheet2 Column A. I would like the rows to display a N/A if the data
is not in the other worksheet. Does anyone know the formula(s) needed to get
this result?

Compare data in 2 worksheets
 

http://www.cpearson.com/excel/Duplicates.aspx


also same site under downloads has a program called compare for downloading


--
Regards,

Peo Sjoblom



"MikeB" wrote in message
...
I have two worksheets of data. Columns A contain the same data in each
workbook (ID #'s). I need to find out if the data in Worksheet1 Column A
is
in Worksheet2 Column A. I would like the rows to display a N/A if the
data
is not in the other worksheet. Does anyone know the formula(s) needed to
get
this result?

Compare data in 2 worksheets
 

Thank-you for your help!

"Peo Sjoblom" wrote:

http://www.cpearson.com/excel/Duplicates.aspx


also same site under downloads has a program called compare for downloading


--
Regards,

Peo Sjoblom



"MikeB" wrote in message
...
I have two worksheets of data. Columns A contain the same data in each
workbook (ID #'s). I need to find out if the data in Worksheet1 Column A
is
in Worksheet2 Column A. I would like the rows to display a N/A if the
data
is not in the other worksheet. Does anyone know the formula(s) needed to
get
this result?