I have a list of names on sheet 1 col B4:B100 and another list of names on sheet2 on col E7:E100, is there is a formula that can luck if the name on sheet 2 col E7:E100 is on sheet 1 col B4:B100 and if the name from sheet 2 col E is not on sheet 1 col B to add the name from sheet 2 col E in to sheet 1 col B, thanks in advance for any help.