+ Reply to Thread
Results 1 to 10 of 10

Using VLookup to pull data out of a list

  1. #1
    Registered User
    Join Date
    01-14-2010
    Location
    philadelphia, pa
    MS-Off Ver
    Excel 2003
    Posts
    28

    Using VLookup to pull data out of a list

    I have two mailing lists. One master list (list A) with over 16k email addresses and one list of about 1k names (list B) that I do not want to mail to. I was told that I can use a VLookup to pull out the names on list B from list A. Does anyone know how to do this?

    Thanks in advance.
    Last edited by Seagood3; 09-21-2012 at 02:10 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    07-27-2012
    Location
    Dublin, Ireland
    MS-Off Ver
    Excel 2010
    Posts
    826

    Re: Using VLookup to pull data out of a list

    Seagood3,

    There are a couple of other threads: http://www.excelforum.com/excel-form...html?p=2926709 and http://www.excelforum.com/excel-form...o-spreadsheets which you may not have found when searching before posting, and may find helpful - they deal with similar scenarios to yours.



    Edited to use correct URL tags.
    Last edited by BB1972; 09-21-2012 at 09:04 AM.
    Brendan.


    __________________________________________________________________________________________________
    Things to consider:

    1) You can thank any poster by clicking the * at the left of a helpful post.
    2) You can help to keep the forum tidy by marking your thread as "Solved", if it has been answered to your satisfaction.
    3) Help us to help you, by uploading a sample workbook, showing the type of data you're dealing with, and clearly indicating what the results should be.

  3. #3
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,054

    Re: Using VLookup to pull data out of a list

    in Column B of list a

    =IF(ISNA(VLOOKUP(A1,ListB!A$1:a$1000,1,false)),"",VLOOKUP(A1,ListB!A$1:a$1000,1,false))

    Col B will show blank if the address is not there or will show the address if it is there
    Use Filter or sort on that column to delete the addresses you dont want
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  4. #4
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Using VLookup to pull data out of a list

    Is this helps you?
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  5. #5
    Registered User
    Join Date
    01-14-2010
    Location
    philadelphia, pa
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Using VLookup to pull data out of a list

    Thank you for your help. My problem has actually change a little now that I actually have the spreadsheets in from of me. The Do not email list is actually a list of domains, not the actual email addresses. So what I did was run a formula to Pull out the domains from the mast list for which I can match the do not email list against.

    column A has the master list of email addresses.
    Column B has just the domains from the master list
    Column C has the do not email list which is just domains.

    I ran a VLookup formula but it is not working and I swear it is right (obviously it isn't). Below is the forumla I used.

    Please Login or Register  to view this content.
    So as I understand it - looking up data in C2:C965, find it in columns A and B, return column 1. Why isn't this working?

  6. #6
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Using VLookup to pull data out of a list

    Why don't you upload a small sample workbook?

  7. #7
    Registered User
    Join Date
    01-14-2010
    Location
    philadelphia, pa
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Using VLookup to pull data out of a list

    Sample.xlsxSample.xlsx

    Here is it is. I highlighted the ones that should be pulled out when the correct formula is run.

    Thanks

  8. #8
    Registered User
    Join Date
    01-14-2010
    Location
    philadelphia, pa
    MS-Off Ver
    Excel 2003
    Posts
    28

    Re: Using VLookup to pull data out of a list

    I read that you may need to have your lists sorted alphabetically, so I did that - but I still got nothing. Please Help!

  9. #9
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Using VLookup to pull data out of a list

    In D2 and copy down,try this.

    =IF(ISNA(INDEX($A$2:$A$14,MATCH(C2,$B$2:$B$14,0))),"",INDEX($A$2:$A$14,MATCH(C2,$B$2:$B$14,0)))

  10. #10
    Registered User
    Join Date
    01-14-2010
    Location
    philadelphia, pa
    MS-Off Ver
    Excel 2003
    Posts
    28

    Thumbs up Re: Using VLookup to pull data out of a list

    solved - thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1