Newbie Q
Newbie confused about how to do the following combined worksheet: (simplified
example) Worksheet 1 ID # Name Email1 1 Bob 2 Sally 3 Mike 4 Greta Worksheet 2 ID # Name email2 1 Bob 2 Sally 4 Greta Worksheet 3 ID # Name Email1 Email 2 1 Bob 2 Sally 3 Mike 4 Greta Basically, the "master" worksheet (1) has all the ID numbers and email 1. Worksheet 2 has the Email Addresses (2) I'd like to use, but some folks from Worksheet 1 don't have Email Address #2. I tried to "Match" and VLookup but I am not sure how to do it (or if I am doing the right thing...since the list #1 has some unique ID numbers. Thanks |
Newbie Q
Thanks Max...worked like a charm! It took awhile for me to figure some things out but you saved me hours of manually checking...my spreadsheet had 4500+ emails to verify with 400 "missing". Come to think of it, you probably saved me days of work :) "Max" wrote: Assume the posted data is in Sheet1/2, cols A to C, data from row2 down Make a copy of Sheet1 (your master), rename it as Sheet3 Then in Sheet3, Label D1 as Email2 Put in D2: =IF(ISNA(MATCH(A2,Sheet2!A:A,0)),"",INDEX(Sheet2!C :C,MATCH(A2,Sheet2!A:A,0))) Copy down -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "dredwin" wrote: Newbie confused about how to do the following combined worksheet: (simplified example) Worksheet 1 ID # Name Email1 1 Bob 2 Sally 3 Mike 4 Greta Worksheet 2 ID # Name email2 1 Bob 2 Sally 4 Greta Worksheet 3 ID # Name Email1 Email 2 1 Bob 2 Sally 3 Mike 4 Greta Basically, the "master" worksheet (1) has all the ID numbers and email 1. Worksheet 2 has the Email Addresses (2) I'd like to use, but some folks from Worksheet 1 don't have Email Address #2. I tried to "Match" and VLookup but I am not sure how to do it (or if I am doing the right thing...since the list #1 has some unique ID numbers. Thanks |
Newbie Q
Welcome, glad it helped. Do take a moment to press the "Yes" button (like the
ones below) in the earlier response. -- Max Singapore http://savefile.com/projects/236895 Downloads:20,500 Files:363 Subscribers:64 xdemechanik --- "dredwin" wrote: Thanks Max...worked like a charm! It took awhile for me to figure some things out but you saved me hours of manually checking...my spreadsheet had 4500+ emails to verify with 400 "missing". Come to think of it, you probably saved me days of work :) |
All times are GMT +1. The time now is 12:16 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com