+ Reply to Thread
Results 1 to 4 of 4

Matching numbers on two lists

  1. #1
    Registered User
    Join Date
    03-18-2016
    Location
    New Zealand
    MS-Off Ver
    2007
    Posts
    29

    Matching numbers on two lists

    Hi everyone,

    I'd like to match a list of numbers on sheet 'Final' to see if they're on list 1 or list 2. If the number in column B is on list 1 or list 1 then in column A there would be a 1 and if the number is not in list either list then have a 0. Please view the attached. If you need more information please let me know.

    I appreciate any help.

    Thanks

    I have excel 2013 but need it for a master file that is on excel 2010.
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Matching numbers on two lists

    Put this in A1 of the Final sheet:

    =IF(COUNTIF(B1,'List 1'!A:A),1,IF(COUNTIF(B1,'List 2'!A:A),2,0))

    then copy down.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    03-18-2016
    Location
    New Zealand
    MS-Off Ver
    2007
    Posts
    29

    Re: Matching numbers on two lists

    I had to switch the countif criteria and range around but then it worked. Thanks

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Matching numbers on two lists

    Ah yes, sorry about that - it's late here, time for bed.

    Pete

+ 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: 2
    Last Post: 05-02-2015, 10:49 AM
  2. [SOLVED] Matching of Lists
    By y0shi in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 04-16-2015, 06:31 AM
  3. Matching between two lists
    By Climaxgp in forum Excel General
    Replies: 3
    Last Post: 02-25-2010, 09:44 AM
  4. Matching lists
    By louhou in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-22-2009, 03:41 PM
  5. Matching four lists of numbers
    By Curalice in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-05-2007, 05:00 PM
  6. Matching two lists?
    By NPgs1uk in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-02-2007, 06:54 AM
  7. [SOLVED] Matching two lists.
    By Jwhite in forum Excel General
    Replies: 1
    Last Post: 03-16-2006, 07:20 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