Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Good news everyone! The Boards.ie Subscription service is live. See here: https://subscriptions.boards.ie/

Excel vlookup question

  • 04-03-2009 02:48PM
    #1
    NeVeR
    Registered Users, Registered Users 2 Posts: 5,360 ✭✭✭


    Hi All.

    I've 2 columns with email address. (alot of emails)

    I need to find out what email address are missing from 1 list,

    can i use a vlookup code to get this info ?

    any help would be great.


Comments

  • #2
    TheBazman
    Registered Users, Registered Users 2 Posts: 6,462 ✭✭✭TheBazman


    I'm sure you can use vlookup but are you not overcomplicating it? Why dont you sort both columns say ascending, and it should be pretty obvious when the two lists go out of sync where you are missing one address. If there are a few missing I would just insert a cell in the missing list everywhere the links are out of sync, thus syncing up the lists again so it will be obvious yet again below this which ones are missing.


  • #3
    Thoie
    Registered Users, Registered Users 2 Posts: 6,340 ✭✭✭Thoie


    If you're feeling lazy, then in column 3 do an =EXACT(A1, B1) and filter for false at the end.


  • #4
    Thoie
    Registered Users, Registered Users 2 Posts: 6,340 ✭✭✭Thoie


    Or if you're feeling really really lazy, try this...
    =IF(ISNA(MATCH(B1,$A$1:$A$6,0)),"X","")


    I put the smaller list in A1 - A6 and the bigger list in the B column. Obviously your list will have more than 6 items (I was just testing), so $A$6 might end up as $A$1000

    Sort both columns, add the code to column 3. X will appear in column 3 whereever there's no match (meaning that something is missing).


Advertisement