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?