Finding matches in two spreadsheets

[Rebecca]

I have two different spreadsheets, both with hospital names on them.
One has about 250 names, one has about 750 names. My client wants me
to determine if there are any names on list one that are also on list
two, and if so, to highlight the names on list to that correspond to
list one.
Is there a way to do this quickly? I do not know much about Excel. I
thought I could use one of the Compare add-in's or the macro that
compares similar spreadsheets but those do not seem to work. Thanks
for your help!

 

[Max]

Assume List1 is in Sheet1, running in A2 down,
List2 is in Sheet2, running in A2 down

In Sheet2,

Put in B2:
=IF(ISNUMBER(MATCH(A2,Sheet1!A:A,0)),"X","")
Copy B2 down. Col B will flag: X where the name matches.
Just autofilter on col B for "X" to get all these cases

If you want to conditionally format it instead,
Select col A (A1 active)
then apply the CF* using Formula is:
=ISNUMBER(MATCH(A1,INDIRECT("Sheet1!A:A"),0))
Format to taste > OK out
This will format names which are found in Sheet1's List1

*Click Format > Conditional Formatting