Search by word and replace with Date from another sheet!

[devpp]

Hi,
I have two sheets "Output","Int".
I have to fill the "Output" sheet's Start and End column with respective dates from "Int" sheet.
The dates have to filled based on the program names.
The attached sheet will clearly show what is required.

[Ingolf]

devpp, why you ask same question in many site?

I should also mention that you put the same question on multiple sites. You get a response from jindon.
Search by word and replace with date (http://www.ozgrid.com/forum/showthread.php?t=193595)

[devpp]

devpp, why you ask same question in many site?

I should also mention that you put the same question on multiple sites. You get a response from jindon.
Search by word and replace with date (http://www.ozgrid.com/forum/showthread.php?t=193595)

My mistake.
Wont do so.

[erpurohit]

alternatively,

We can get the dates without using code, attached is the version with only excel's array formulas.

1764

[Ingolf]

Why not normal formula?

E4 =SUMPRODUCT((Int!$A$2:$A$13=Int!$A$2)*(Int!$B$2:$B $13=$C4)*(Int!$C$2:$C$13))
F4 =SUMPRODUCT((Int!$A$2:$A$13=Int!$A$2)*(Int!$B$2:$B $13=$C4)*(Int!$D$2:$D$13))