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
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

Excel vlookup question

  • 04-03-2009 1:48pm
    #1
    NeVeR
    Registered Users, Registered Users 2 Posts: 5,356 ✭✭✭


    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,344 ✭✭✭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,344 ✭✭✭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