Hi I have 2 sheets.

On one sheet I have first and last name and other information.
On sheet 2 I have first and last name and other information.

But, sheet 2 does not have all the ppl from sheet 1. ie some are missing.

What I want to do is on sheet 1, identify who is not on sheet 2.

I have tried vlookup and match but can't seem to get it right.

The problem of course is that the last name can be repeated and the first
name can be repeated but not the combination of both.