matching text in two different list.

Here's a link that may help?

http://office.microsoft.com/en-gb/he...039151033.aspx

Originally Posted by mik00725

I have a list of names in Sheet 1 column A. I need to compare this list to another list of names in another sheet, and retrice only the matching names in the two list. Is there any macros or fomula to do this?

Hi
You need to attach a sample file in zip format.