I want to transfer the id number in sheet 1 to blank id number in sheet 2 where last name and first name is equal. In sheet 1 and sheet 2 I have id number, last name, and first name columns, but the sheet 2 has blank id number that can be found in sheet 1.
I’m looking for an Excel formula that solves the problem.
New contributor
nefer pitou is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
2