Hi there. I am having a problem with cross-referencing two sheets and attaining information that appears on both.

I am compiling a master list of people for an organization. Let us call this Master List Sheet 1. However, it is not yet complete and needs information from another list we will call Sheet 2. I need Excel to search Sheet 2's list of people for individuals appearing in Sheet 1. If a person appears in both, then I want to copy the important information such as phone number, address, email, etc into the respective columns in Sheet 1. If you need any further information, just ask. Thanks!