Cross referencing, fidning matching data

  • Thread starter Thread starter samjwoods
  • Start date Start date
S

samjwoods

Hi,
I need to search between two sets of names to cross reference and find any
matches. The data will not have been formulated from elsewhere it will just
be lists of names (either on the same sheet or separate whichever is easier).
Is there a way to do this with Excel?
Thanks for any responses,
Sam Woods
 
With your first list in Sheet1 Column A and the second one in Sheet2 Column A
;use the below formula in Sheet1 cell B1 and copy down. This will return
'Match found' if a match is found in Sheet2

=IF(ISNA(MATCH(A1,Sheet2!A:A,0)),"","Match found")

If this post helps click Yes
 
If you had the first list of names in column A and the second in column C
then put this in B1 and copy down:

=COUNTIF(C:C,A1)

and this is D1 and copy down

=COUNTIF(A:A,C1)

Anywhere the result is not 0 means you have a match.
 
How do I modify this for my situation. I have a a master list of bus route
numbers. I have two lists from separate consultants showing desired changes.
I want to see which routes the consultants agree need to be changed. I
think I need to use and or or but I don't know.
 
This was very helpful although I used these together. I wanted a formula
next to the master list that looked at both sub-lists to see if there was a
match. I ended up using both of these formulas into one formula and if the
answer was 2 then there was a match between the two sub-lists. Thank you for
your help.
 
Back
Top