Compare worksheets in two workbooks

[edn hello]

I have 2 worksheets. Column A in both is SSN. I want to compare the data in
column L of worksheet 1 to column H of worksheet 2. I basically need a
formula that will compare the data in worksheet 1 column L to worksheet 2
column H, and correspond to the correct SSN. The values of the 2 columns
should be the same, but I need to know when they're not.

 

[Max]

Data assumed in row2 down

In Sheet1,
Put in say, M2:
=IF(A2="","",IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"SSN not found in
Sheet2",IF(L2=INDEX(Sheet2!H:H,MATCH(A2,Sheet2!A:A,0)),"OK","Check")))
Copy down as far as required

Then you could autofilter on col M as desired,
eg choosing: Check
will filter the lines where col L (in Sht1) <> col H (in Sht2)