Advertisement
Help Keep Boards Alive. Support us by going ad free today. See here: https://subscriptions.boards.ie/.
If we do not hit our goal we will be forced to close the site.

Current status: https://keepboardsalive.com/

Annual subs are best for most impact. If you are still undecided on going Ad Free - you can also donate using the Paypal Donate option. All contribution helps. Thank you.
https://www.boards.ie/group/1878-subscribers-forum

Private Group for paid up members of Boards.ie. Join the club.

Excel vlookup question

  • 04-03-2009 01: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