Trying to determine if data matches from one sheet to another

I have a workbook with two sheets containing employee names and phone numbers. One was run last october, and one was run today. I am looking to determine who's telephone numbers have changed since October, so that we have the correct number's on file. I don't want to copy and paste, as there may be employees that are on one list and not the other, and there are over 1000 records. I would like to have a Yes/No result in the Changed? column on sheet 1.

Also, I have alt. telephone on sheet 1 that I would like copied to sheet 2 when an exact name match is found. Is that possible as well?

I've attached a small sample. Name's have been abbreviated, and phone numbers are made up ones.

When I use the formula on the actual sheet, about 10-15 names down, the names change. "Tom Jones" is on sheet 2, but not on sheet 1. When I use the formula given on sheet 1, it tells me that "John Smith" has a changed phone number when he doesn't, because it is comparing John's # with Tom's #. It continues to say Changed for every person after that because it's comparing the # for the wrong person.

So because the names aren't the same on both sheets, every name after the first missing name that says the number is changed because it isn't comparing the names to make sure it's checking the phone # for the correct person.

So I'm going to have to go through 1000+ names to figure out where it is different in the two sheets, so I can adjust the range for the telephone # each time that happens (it happens more than once)? There's no easier way?

Oooohhhh! That makes so much more sense. I'm a little slow today..

Nope, still not doing what I need. I updated the formula with the correct range and it hit #61 and said his number changed, but it is comparing it to #61 on the original which is a different person. So everyone #61 and later say changed, but they aren't.

Excellent. Now it seems to be doing exactly what I need. Thank you so much!