Search by word and replace with Date from another sheet!

[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

[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

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.

ABC1.xlsx

[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))