I am trying to do an index-match with multiple matches. So, an array formula as I understand. It's my first attempt at it alone...didn't work.
I am trying to return a time stamp based on 2 matches: date and flight number.
I have attached a sample workbook with 2 sheets.
I have highlighted what I am trying to return in the cell with color highlighting.
I am curious, one of the extracted data sets appears to have several possible matches (i.e. MVTs cells G6:G9; ideally there would only be one match in the data set). Could this result in the #N/A? How does the array handle it when there are multiple possible matches, the first one or an #N/A?
Bookmarks