comparing two worksheets

  • Thread starter Thread starter mikeymosjr
  • Start date Start date
M

mikeymosjr

I am trying to compare two lists of names on seperate workbooks. How can I
have excel match the names on both workkbooks and place that info in another
worksheet? I want to take names that are on both worksheets and place them in
another.
 
This sounds like a job for a database. Any chance that you know how to use
Access? If not, try this...

Data is in ColA (two seperate workbooks), select D1:D6, and enter
=IF(NOT(ISERROR(MATCH('[Sheet1]Master#1'!A1:A6,'[Task2.xls]Master#2'!$A$1:$A$6,0))),'[Sheet1]Master#1'!A1:A6,"")

Commit with Ctrl + Shift + Enter, not just Enter.
 
Back
Top