Hi,

Firstly, apologies if this is in the wrong place, newcomer to the site (although have received help from articles on here before) and still getting used to it.

Secondly, my problem:
I have two different documents, for ease, lets say, file 1 and file 2.
File 1 has one column which contains clients names (first and second name in same cell, separated by a space).
File 2 has three columns, column A has first names, column B has surnames and column C has phone numbers.

What I'm trying to do is compare the data so that any duplicate names from file 1 and file 2 are shown and the number highlighted.

Is it possible to do this, if so can someone tell me how?

Thanks
David