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

Array Formulas Cell Formula H2 =IFERROR(INDEX([Active Date],MATCH(1,([Enterprise Yes/No]="Yes")*([Enterprise ID:]=[@[Enterprise ID:]])*([Product]="MIL Site"),0)),"-") I2 =IFERROR(INDEX([Active Date],MATCH(1,([Enterprise Yes/No]="Yes")*([Enterprise ID:]=[@[Enterprise ID:]])*([Product]="CRM"),0)),"-") J2 =IFERROR(INDEX([Active Date],MATCH(1,([Enterprise Yes/No]="Yes")*([Enterprise ID:]=[@[Enterprise ID:]])*([Product]="IH & Lite CMB"),0)),"-") <tbody> </tbody>

<tbody>
</tbody>

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.