Results 1 to 7 of 7

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

Threaded View

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

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

    Hello,

    I have a "CALENDAR" tab which includes subject ID (column B), the date of visit (column A), and a list of tasks (rest of the columns). Under each column I record the date the subject completed the task. On the tab "TASK_COMPLETION_LIST" I have a list of all subject IDs in column A and the diferent tasks are the headers of the rest of the columns.

    I want to write a lookup formula in each cell of the "TASK_COMPLETION_LIST" tab that will return the date the subject completed the task. The tricky part is that same subject may come in multiple times on different days and complete different tasks on different days so the lookup function needs to be able to find multiple matches and return only the cell that is not empty (in theory each subject will have to complete each task only once).

    For example, I need a formula that I can put in cell B10 of the "TASK_COMPLETION_LIST" tab and drag across to fill th rest of the columns. I am trying an index and match function with multiple criteria but its not working for me.

    Thank you for your help.

    Miguel
    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