How to compare 4 columns in Excel

Question

I have 4 columns first two are First Name and Last Name the other two are the same. The data comes from two different spreadsheets. I need to see if any names from the first two columns match any in the last two columns.

Thanks!

Answer 1

Create a fifth column containing the full names from columns 1 & 2. Use TEXTJOIN or a simple concatenation formula. Do the same in a sixth column with the data form columns 3 & 4.

Write (or record) a little macro that attempts to FIND the contents of the active cell in column 6. Invoke the macro from each cell in column 5