That works perfect, only one problem. Sometimes there are SSN in Sheet 2 that will not be in Sheet 1 (new people that I will need to add to Sheet 1). Anyway if a SSN is not found to prompt me to add that SSN with their Name to Sheet 1?? Thanks again!