Help matching milestones that are all on different lines, but all relate to one applicati

Hello Everyone, this is my first post, and I do not anticipate it to be my last!

I've assumed a program management role at a prominent company and need some help with a function that I just do not have the level of skill to build myself.

I've attached an example file to walk you through what I need because I simply don't know how to put it into words without showing it. I REALLY hope I don't butcher this but I think you all are smart enough to understand either way.

My request:

On the "EXAMPLE - Source Data" Tab, you can see that there are three columns: Column A - Task description, Column B - The date, Column C - Related To

What I need on the Example - Target tab: Columns B and C (any fields that say "Need Date") to match what text is in the respective column header with the the associated "Parent Application Name" and populate that date FROM the "EXAMPLE - Source Data" tab array. I do not how to do these partial matches.

The problem is, that in the source data, the task descriptions combine both and they do not have a unique identifier associated with each that would tie it to the parent application.

Can you all please help me? I'm desperate for an answer.

Apologies, it wouldn't let me attach it because it was too large.

I've uploaded the file to dropbox and attached it here, and followed AliGW's advice.

https://www.dropbox.com/s/km20hapl7k...20Me.xlsx?dl=0

Hi JeteMC, I appreciate your help on this matter.

When I do input that formula, I am getting a #VALUE response, rather than the associated date. I'm going to attach another file with the exact same names of tabs, fields, that I need to work together. They're in the exact placement that they will be in my working spreadsheet. I've got the formula entered exactly as you showed and I'm just wondering where that disconnect is. Please find the dropbox link below! Thanks!

https://www.dropbox.com/s/c1fiypxnns...%201.xlsx?dl=0

I've attached it here, again my apologies

in M4

=SUMPRODUCT(IFERROR(--(ISNUMBER(SEARCH(M$1,'SOURCE DATA - Tasks'!$C$8:$C$14)))*--ISNUMBER((SEARCH($C4,'SOURCE DATA - Tasks'!$C$8:$C$14)))*('SOURCE DATA - Tasks'!$V$8:$V$14),FALSE))

in R4

=SUMPRODUCT(IFERROR((ISNUMBER(SEARCH(R$1,'SOURCE DATA - Tasks'!$C$8:$C$14)))*(ISNUMBER((SEARCH($C4,'SOURCE DATA - Tasks'!$C$8:$C$14))))*('SOURCE DATA - Tasks'!$V$8:$V$14),FALSE))

is S4

=SUMPRODUCT(IFERROR(--(ISNUMBER(SEARCH(S$1,'SOURCE DATA - Tasks'!$C$8:$C$14)))*--ISNUMBER((SEARCH($C4,'SOURCE DATA - Tasks'!$C$8:$C$14)))*('SOURCE DATA - Tasks'!$Q$8:$Q$14),FALSE))

ALL entered with Ctrl+Shift+Enter

Originally Posted by JohnTopley

in M4

=SUMPRODUCT(IFERROR(--(ISNUMBER(SEARCH(M$1,'SOURCE DATA - Tasks'!$C$8:$C$14)))*--ISNUMBER((SEARCH($C4,'SOURCE DATA - Tasks'!$C$8:$C$14)))*('SOURCE DATA - Tasks'!$V$8:$V$14),FALSE))

in R4

=SUMPRODUCT(IFERROR((ISNUMBER(SEARCH(R$1,'SOURCE DATA - Tasks'!$C$8:$C$14)))*(ISNUMBER((SEARCH($C4,'SOURCE DATA - Tasks'!$C$8:$C$14))))*('SOURCE DATA - Tasks'!$V$8:$V$14),FALSE))

is S4

=SUMPRODUCT(IFERROR(--(ISNUMBER(SEARCH(S$1,'SOURCE DATA - Tasks'!$C$8:$C$14)))*--ISNUMBER((SEARCH($C4,'SOURCE DATA - Tasks'!$C$8:$C$14)))*('SOURCE DATA - Tasks'!$Q$8:$Q$14),FALSE))

ALL entered with Ctrl+Shift+Enter

Did exactly as you said and all fields are now returning "0" and when converted to a date "1/0/1900"

In the file from post #9, column B ("Milestones") was blank and the "milestone" data appeared to be in C e.g MS: Application Project Start: Application A - TEST / MS: Infrastructure Design: Application A - TEST: hence the choice of column C. I note column D has the "Application A - TEST".

It returned dates for me.

Solved! Thank you all.