+ Reply to Thread
Results 1 to 4 of 4

Need to Return A Value In Cell When Two Criteria Match

  1. #1
    Registered User
    Join Date
    04-11-2017
    Location
    San Antonio, TX
    MS-Off Ver
    Microsoft Office Standard 2013
    Posts
    6

    Need to Return A Value In Cell When Two Criteria Match

    I need to match last names and dates of birth to return an account number. I have found a solution previously in the forums, but can't seem to find it now!

    I have two sheets, one that has a BUNCH of people listed, their names, their dates of births and their account numbers. The other list has the last names and dates of birth, but no account numbers. I need to match the last names and dates of birth to return the account number. Example attached!
    Attached Files Attached Files

  2. #2
    Spammer
    Join Date
    01-08-2015
    Location
    Cali, Colombia
    MS-Off Ver
    365
    Posts
    302

    Re: Need to Return A Value In Cell When Two Criteria Match

    Hi, mfelux!

    You can try:
    [C2] : =SUMIFS('Master List'!D:D,'Master List'!A:A,A2,'Master List'!C:C,B2)

    Blessings!

  3. #3
    Registered User
    Join Date
    04-11-2017
    Location
    San Antonio, TX
    MS-Off Ver
    Microsoft Office Standard 2013
    Posts
    6

    Re: Need to Return A Value In Cell When Two Criteria Match

    Ok I got it to work - some of the numbers were stored as text - thank you!!

  4. #4
    Spammer
    Join Date
    01-08-2015
    Location
    Cali, Colombia
    MS-Off Ver
    365
    Posts
    302

    Re: Need to Return A Value In Cell When Two Criteria Match

    Hi, again!

    If you have text and/or numbers, you can use this instead:
    [C2] : =INDEX('Master List'!D$2:D$8,MATCH(1,INDEX(('Master List'!A$2:A$8=A2)*('Master List'!C$2:C$8=B2),),))

    Blessings!

+ 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. SUMIFS, If no criteria match, leave cell blank, else return value
    By eemiller1997 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-03-2017, 02:10 AM
  2. Replies: 5
    Last Post: 07-02-2017, 10:25 AM
  3. Multiple criteria match to return adjacent cell value
    By Adam859 in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 02-05-2016, 06:19 PM
  4. [SOLVED] How to return value blank cell, if criteria do not match
    By devawad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-25-2013, 08:14 AM
  5. [SOLVED] How to return value blank cell, if criteria do not match
    By devawad in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-25-2013, 05:21 AM
  6. Match two criteria to return one cell data
    By rogersst33 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-16-2012, 09:32 AM
  7. Replies: 3
    Last Post: 08-17-2010, 02:54 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