Compare data in 2 worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
Back
Top