Compare data in 2 worksheets

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top