View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edn hello edn hello is offline
external usenet poster
 
Posts: 1
Default Compare worksheets in two workbooks

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.