Copy Value of Cell from other Rows based on Multiple Criterias

[pbsmith82]

I am having trouble setting some automation. It works best if I explain I have three types of "Products" these products can be purchased Separately or as a collection. The can be "Completed" at different times. I collect the data as separate projects, but need to see them as a collection also ........ With that said Here is what I am trying to do.

If Collection is a Yes, I want Product A's , from Collection A, Active date Pasted to Cell X

AND

If Collection is a Yes, I want Product B's , from Collection A, Active date Pasted to Cell Y

AND

If Collection is a Yes, I want Product B's , from Collection A, Active date Pasted to Cell Z

See Image Below ....

 

[jondavis1987]

I Did Fluff's formula on your sample workbook and it worked quite well. if it's the dash that you want in there you'll have to amend it to

[TABLE="class: cms_table, width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="class: cms_table, width: 100%"]
<tbody>[TR]
[TH="align: center"]Cell[/TH]
[TH="align: center"]Formula[/TH]
[/TR]
[TR]
[TH="align: center"]H2[/TH]
[TD="align: left"]=IFERROR(INDEX([Active Date],MATCH(1,([Enterprise Yes/No]="Yes")*([Enterprise ID:]=[@[Enterprise ID:]])*([Product]="MIL Site"),0)),"-")[/TD]
[/TR]
[TR]
[TH="align: center"]I2[/TH]
[TD="align: left"]=IFERROR(INDEX([Active Date],MATCH(1,([Enterprise Yes/No]="Yes")*([Enterprise ID:]=[@[Enterprise ID:]])*([Product]="CRM"),0)),"-")[/TD]
[/TR]
[TR]
[TH="align: center"]J2[/TH]
[TD="align: left"]=IFERROR(INDEX([Active Date],MATCH(1,([Enterprise Yes/No]="Yes")*([Enterprise ID:]=[@[Enterprise ID:]])*([Product]="IH & Lite CMB"),0)),"-")
[/TD]
[/TR]
</tbody>[/TABLE]

[/TD]
[/TR]
</tbody>[/TABLE]

Like Fluff said, when you copy those formulas into the formula bar make sure you hit ctrl shift enter

 

[Fluff]

Never Mind I did Get it to work Thanks you!!!!!!

Glad it's working & thanks for the feedback.

Also please do not quote entire posts, as it just clutters up the thread.