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.

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"mikeymosjr" wrote:

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.