View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Allllen Allllen is offline
external usenet poster
 
Posts: 341
Default How do I match identical data from two different worksheets in one

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

http://www.datapigtechnologies.com/f...s/vlookup.html

--
Allllen


"Myrto" wrote:

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 ?
--
Myrto