comparing two worksheets

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.
 
R

ryguy7272

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Crating User Form to Add Names 1
Scrubbing two excel worksheets, returning unique values from one sheet 0
Comparing two lists 0
Custom Number sequences 0
Drop down lists in seperate columns 5
Inconsistent formatting of section numbers 0
Finding the right style field in VBA 0
Is a combination of INDIRECT with INDIRECT.EXT, a component ofmorefunc.xll by Laurent Longre, valid? 1

Top