Results 1 to 4 of 4

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

Threaded View

we-ed Return if values in a list... 12-13-2013, 12:10 AM
FDibbins Re: Return if values in a... 12-13-2013, 12:57 AM
sktneer Re: Return if values in a... 12-13-2013, 01:13 AM
kvsrinivasamurthy Re: Return if values in a... 12-13-2013, 06:23 AM
  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

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