+ Reply to Thread
Results 1 to 10 of 10

Vlook names

  1. #1
    Registered User
    Join Date
    09-14-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    15

    Vlook names

    Hello all! I am in need of a simple "formula" that I could use on a daily to see which names are not on my spreadsheet. The names in column A/B will always be the same, but columns D/E will be the ones that constantly change.

    Attached is my spreadsheet. If you could also explain how you did it, I would greatly appreciate it.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Vlook names

    Insert a new column right next to column B. In C2, enter this array formula with Ctrl + Shift + Enter keys together
    =IF(ISERROR(MATCH(A2&B2,$E$2:$E$320&$F$2:$F$320,0)),"Nope","Yes")
    Attached Files Attached Files

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Vlook names

    "see which names are not on my spreadsheet. The names in column A/B will always be the same, but columns D/E will be the ones that constantly change."

    It sounds like you do not want to see which names are not on your spreadsheet. It sounds like you want to see which names in one list are not in the other list. Do you want to know which name in D/E do not appear in A/B?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Registered User
    Join Date
    09-14-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    15

    Re: Vlook names

    Thank you for the reply. But I don't need to know if they match line by line... I need to know which names don't match anywhere on the spreadsheet.

    Example: I know for sure that D43: Caputo, Roy is not in Column A.

  5. #5
    Registered User
    Join Date
    09-14-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    15

    Re: Vlook names

    My apologies for the confusion. Column A/B is my MASTER LIST. Correct, I need to know which names are NOT on other list.

    Using A2: Abdel-Malek, Shahira (MASTER LIST) and D43: Caputo, Roy (HP LIST) as examples, is there a way to have them called out as not being on each others list? or do I have to put them each on different tabs? Sorry for not being able to explain myself better.

    I have attached an updated spreadsheet.
    Attached Files Attached Files

  6. #6
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Vlook names

    Did you review JieJenn's response? I haven't tried it but I think that is what you want.

  7. #7
    Registered User
    Join Date
    09-14-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    15

    Re: Vlook names

    I have and all it did was come back with NOPE all the way down.

    Capture.JPG

  8. #8
    Forum Expert
    Join Date
    12-15-2009
    Location
    Chicago, IL
    MS-Off Ver
    Microsoft Office 365
    Posts
    3,177

    Re: Vlook names

    Because your formula is looking at columns reference Column E and Column F instead of Column D and Column E. Try to understand the formula first, don't just copy and paste.

  9. #9
    Registered User
    Join Date
    09-14-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    15

    Re: Vlook names

    I feel bad that I can't put into words what I need. Hopefully the picture below helps. The ones highlighted do NOT have a match on either list. JieJenn's response seemed to match them line by line. But as you can see, I need it to check the entire sheet. Ex: Agajanian, Richy is on Master List A8 and HP LIST D3. But Abdel-Melak, Shahira is only MASTER LIST A3.

    Capture1.JPG

  10. #10
    Registered User
    Join Date
    09-14-2016
    Location
    California
    MS-Off Ver
    2010
    Posts
    15

    Re: Vlook names

    and that is where I failed. again, I apologize, I am not smarter than a 5th grader. If you would kindly explain I would greatly appreciate it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 06-12-2013, 04:58 PM
  2. Replies: 1
    Last Post: 06-07-2012, 12:23 PM
  3. Replies: 1
    Last Post: 05-14-2012, 10:14 AM
  4. vlook up
    By syed abbas in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-12-2007, 06:10 AM
  5. [SOLVED] vlook up
    By KL in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-06-2005, 03:05 PM
  6. vlook up
    By Sean in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  7. vlook up
    By KL in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-06-2005, 07:05 AM
  8. [SOLVED] VLOOK
    By Adnan in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-18-2005, 12:05 PM

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