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?

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


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


--
Regards,

Peo Sjoblom



"MikeB" <(E-Mail Removed)> wrote in message
news:B3280B76-E439-44EA-B538-(E-Mail Removed)...
>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?

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" <(E-Mail Removed)> wrote in message
> news:B3280B76-E439-44EA-B538-(E-Mail Removed)...
> >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?
>
>
>