Finding identical names across 3 spreadsheets

Hi,

Yes there are probably several ways. One way would be first create a helper column in each sheet which concatenates the first and last name in a single cell. Then in two other columns add a VLOOKUP() formula that looks up the combined names in each of the other two workbooks/sheets. Then extract from the 3 workbooks/sheets those names where the VLOOKUP()s in the two columns are both true and stack these three ranges underneath each other in a single column.

Finally perform a data filter advanced with the unique parameter selected to extract a list of all the unique names.

HTH