Results 1 to 7 of 7

help with index and match that returns value based on multiple criteria

Threaded View

  1. #3
    Registered User
    Join Date
    09-27-2021
    Location
    barcelona
    MS-Off Ver
    365
    Posts
    3

    Re: help with index and match that returns value based on multiple criteria

    Hello,

    Thanks GeoffW283 for your response! I tried the formula but it doesnt produce the desired results. For example I entered it in cell B5 of the "TASK_COMPLETION_LIST" tab and it gives back a date which does not correspond to the date that subject completed the task. The date each subject completed each task is in the "CALENDAR" tab.I attached another excel file which I think is clearer. The desired results are in rows 2 and 3 of the "TASK_COMPLETION_LIST" tab.
    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. Index Match with multiple criteria returns and error
    By mattdamon33 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-24-2021, 06:13 AM
  2. Replies: 1
    Last Post: 03-01-2020, 10:36 PM
  3. Replies: 1
    Last Post: 01-18-2019, 03:55 PM
  4. How to sum Index/Match based on multiple criteria ?
    By donny007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-18-2019, 02:06 AM
  5. [SOLVED] Index-Match based on multiple criteria
    By JBR9999 in forum Excel General
    Replies: 2
    Last Post: 09-01-2016, 02:14 PM
  6. [SOLVED] Index/Match based on multiple criteria
    By BB1972 in forum Excel General
    Replies: 7
    Last Post: 08-17-2012, 11:45 AM
  7. Index and Match Based on Multiple Criteria
    By duranbeaz in forum Excel General
    Replies: 2
    Last Post: 05-22-2009, 04:37 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