Hello, I am new to excel and any help would be greatly appreciated. I have 2 sheets with 2 columns each. First column in sheet 1 is a name, and second column is an ID number. Second sheet is also a name, and ID numbers.

I need the ID numbers that are on sheet 1 copied to sheet 2 if the names are on both lists. How can I go about doing this?