Linking 1 tab to another based on a cell result, picks a column based on result formula

Good morning all

I'm having trouble with a formula that I was trying to do as an IF statement but not sure if that is the right thing to do!

I have 2 tabs in the spreadsheet: One called Scheduler the other called Data.

What I want is the information from the Data tab to pull through to the Scheduler tab.

Columns A to C pull through nicely, but what I am having trouble with is column J.....

What I want to do is depending on what is in column C (called Stage Gate Status) to show the correct date from the data tab in column J.

For example:

Ghost House shows column C as Define & Design so from the Data tab will need to pull through to column J the date under Define & Design in Data tab which would be the 23/07 I believe.
Dracula House is Initiation in columns C so in the Data tab will need to pull through 10/9 to column J
Mummy House is Build & Deliver so Data tab 20/09 to column J

Hope that makes sense

Thanks y'all

:-)

Assuming that only one date is filled in on that row on the data sheet (as in the sample workbook), try this:

=SUMPRODUCT((--Table_owssvr[[Initiate Health Check]:[Closure Health Check]])*(Table_owssvr[Title]=Scheduler!A9)*(Table_owssvr[Current Stage Gate]=Scheduler!C9))

It would be appreciated if you would change your thread title to better describe the issue at hand, please.

Please try at J9

Formula:

Please Login or Register  to view this content.

Thanks for the rep and for marking the thread as solved.