Results 1 to 7 of 7

Best way to find multiple matches

Threaded View

  1. #1
    Registered User
    Join Date
    09-29-2015
    Location
    Chicago, IL
    MS-Off Ver
    2010 and 2013
    Posts
    1

    Best way to find multiple matches

    Hi all - first time forum user, thanks in advance for help.

    I have several sheets in a workbook. The first contains the ID#s of anyone who attended a conference. The other sheets have the ID#s of new members. I want to see if ANY of the IDs at the conference match ANY of the IDs in new members.

    So for example, I have NTPParticipants!E:E dedicated to the IDs of members who attended the conference. (Some are blank because not all attendees were members.) Then in FebNewMem!A:A are all the ID#s of new members that signed up in February. I want to know if anyone who signed up in February is listed on the NTPParticipants sheet, i.e. does any cell in FebNewMemA:A = NTPParticipants!E:E. (Then eventually does any cell in MarNewMem!A:A = NTPParticipants!E:E, and for april, may, etc.)

    I've tried countif, countifs, index, match... not really sure what to use here. If I were only looking for a particular value or cell, maybe the ID#222111, then I would just use countif(FebNewMem!A:A,"=222111"), but this doesn't seem to be working when the criteria isn't a specific value or cell.

    So what's my best option? Thanks!Participants vs New Members sample .xlsx
    Last edited by megantscherer; 09-29-2015 at 12:50 PM. Reason: Attached sample spreadsheet

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to use a multiple criteria index search with to find all matches
    By bossmanamr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-20-2015, 09:41 PM
  2. Replies: 4
    Last Post: 05-10-2015, 02:11 PM
  3. [SOLVED] What formulas can I use to find matches based on multiple criteria
    By Jonathan68 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-21-2014, 02:22 PM
  4. To find if vlookup matches multiple values
    By karthik11 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-06-2013, 06:19 AM
  5. Find unique matches for multiple criteria within a row of cells
    By Chase in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-06-2012, 03:11 PM
  6. Replies: 8
    Last Post: 02-15-2012, 05:05 AM
  7. Find the last-row result of multiple matches?
    By goodiein2808 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-08-2011, 11:53 AM

Tags for this Thread

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