Identify range based on multiple criteria and replace with value based on another value

[Shummy]

Hello.

Thanks for your help.

I have a large data set in which I need to identify the range in Column C based on the repeated values in 2 columns. Once the range is identified, I need to replace the values in the range based on a value in Column D ({CandidateHeader.Email}). For Column C, all User Names will be replaced with the name corresponding to the value {CandidateHeader.Email}.

Sample set below:

Req ID	Cdd ID	User	Correspondence
12345A	98765	User A
12345A	98765	User B	Random Text
12345A	98765	User C	{CandidateHeader.Email}
12345A	98765	User A	Random Text
12345A	98765	User A	Random Text

Expected result:

Req ID	Cdd ID	User	Correspondence
12345A	98765	User C
12345A	98765	User C	Random Text
12345A	98765	User C	{CandidateHeader.Email}
12345A	98765	User C	Random Text
12345A	98765	User C	Random Text

The Req ID and Cdd ID won't all necessarily be 5 lines. For {CandidateHeader.Email}, most cases will only have one User name corresponding to it, however if there is a case in which {CandidateHeader.Email} appears twice in a range, it will pick up only the first occurrence.

I appreciate the help.

Thanks.

Regards,
Chris