ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   How do I match identical data from two different worksheets in one (https://www.excelbanter.com/new-users-excel/118742-how-do-i-match-identical-data-two-different-worksheets-one.html)

Myrto

How do I match identical data from two different worksheets in one
 
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

Allllen

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



All times are GMT +1. The time now is 06:59 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com