How do I match identical data from two different worksheets in one

[Guest]

Hallo,

I have two lists :A with 3 Columns: Name, First Name, E-mail
and list B with 7 Columns : Name, First Name, Street, City, Region, Post
Code and Counrty
The names of list A are included in the list B. How can I have the names and
the e-mail addresses of list A matched with the names of list B ?

 

[Guest]

use a VLOOKUP in the second sheet to pull in the information from the first
sheet.

http://www.datapigtechnologies.com/flashfiles/vlookup.html