+ Reply to Thread
Results 1 to 4 of 4

Return if values in a list contains criteria and return multiple corresponding values

  1. #1
    Registered User
    Join Date
    08-27-2010
    Location
    Singapore
    MS-Off Ver
    Excel 2003
    Posts
    1

    Return if values in a list contains criteria and return multiple corresponding values

    I have 2 problems that is difficult:

    Return ID if date & name meet criteria:
    If Sheet1 date is with the range of Master End Date (+/- 5 days) and Sheet1 name contains Master name, it has to return Master ID of the corresponding cell.

    Return all ID if date meet criteria:
    If Sheet1 date is with the range of Master End Date (+/- 5 days), return all corresponding ID.


    Thanks for all help.
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,801

    Re: Return if values in a list contains criteria and return multiple corresponding values

    Hi and welcome to the forum

    The names on the 1st sheet do not match the names on the 2nd sheet...Lobie & Dan Lobie etc. It will make things much simpler if you have the same names in each list
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,640

    Re: Return if values in a list contains criteria and return multiple corresponding values

    As the Ford suggested, make the names similar in both the sheets and try the formulas given below to see if this is what you want.

    Both the formulas are array formulas so they need to be confirmed with Ctrl+Shift+Enter.

    Please Login or Register  to view this content.
    Ctrl+Shift+Enter and copy it down

    Please Login or Register  to view this content.
    Ctrl+Shift+Enter and then copy across and down
    Last edited by FDibbins; 12-13-2013 at 01:15 AM. Reason: fixed a == error :)
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

  4. #4
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2010
    Posts
    7,011

    Re: Return if values in a list contains criteria and return multiple corresponding values

    Pl see the attached file.
    Attached Files Attached Files

+ 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. [SOLVED] How to look up a value in a list and return multiple corresponding values
    By Clash in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-23-2013, 09:49 AM
  2. Look up a value in a list and return multiple corresponding values
    By Jord- in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-19-2011, 09:04 AM
  3. Replies: 6
    Last Post: 07-26-2011, 04:36 PM
  4. Replies: 3
    Last Post: 11-03-2010, 04:05 AM
  5. Replies: 7
    Last Post: 12-06-2006, 12:12 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