IF Row has same value in sequence then change row C?

[AndyGray]

Hi Guys, I'm trying to change the value on row C based on Row D sequencing....
Example.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sold to C1
[/TD]
[TD]Business person D1
[/TD]
[/TR]
[TR]
[TD]Plastic Company Index c2
[/TD]
[TD]Plastic Company d2
[/TD]
[/TR]
[TR]
[TD]Small Plastic Company c3
[/TD]
[TD]Plastic Company d3
[/TD]
[/TR]
[TR]
[TD]Small window firm c4
[/TD]
[TD]Plastic Company d4
[/TD]
[/TR]
[TR]
[TD]Small bathroom fitter c4
[/TD]
[TD]Plastic Company d5
[/TD]
[/TR]
[TR]
[TD]Flooring Company Index c6
[/TD]
[TD]Flooring Company d6
[/TD]
[/TR]
[TR]
[TD]Flooring Company Index c7
[/TD]
[TD]Flooring Company d7
[/TD]
[/TR]
[TR]
[TD]Small Floor Company c8
[/TD]
[TD]Flooring Company d8
[/TD]
[/TR]
[TR]
[TD]Small Floor Company c9
[/TD]
[TD]Flooring Company d9
[/TD]
[/TR]
[TR]
[TD]Trade Person Index c10
[/TD]
[TD]Trade Person d10
[/TD]
[/TR]
</tbody>[/TABLE]

I need c2 to line up with D 2 3 4 and 5
Then I need C6 to line up with D7 8 and 9
and obviously C10 line up with D 10.

I tried in Cell C2 If D2=D1 Then Display cell C1. if not Display C2.... this never worked. Any suggestions are welcome.

 

[Roderick_E]

build the two lists on a sheet you will hide, then do an index/match to get the result