Aligning 2 different columns of data from same date

[rush1884]

[TABLE="width: 500"]
<tbody>[TR]
[TD]1/1/18
[/TD]
[TD]20
[/TD]
[TD]1/1/18
[/TD]
[TD]12
[/TD]
[TD]20
[/TD]
[/TR]
[TR]
[TD]2/1/18
[/TD]
[TD]25
[/TD]
[TD]1/1/18
[/TD]
[TD]16
[/TD]
[TD]20
[/TD]
[/TR]
[TR]
[TD]3/1/18
[/TD]
[TD]35
[/TD]
[TD]1/1/18
[/TD]
[TD]15
[/TD]
[TD]20
[/TD]
[/TR]
[TR]
[TD]4/1/18
[/TD]
[TD]32
[/TD]
[TD]2/1/18
[/TD]
[TD]4
[/TD]
[TD]25
[/TD]
[/TR]
[TR]
[TD]5/1/18
[/TD]
[TD]80
[/TD]
[TD]2/1/18
[/TD]
[TD]56
[/TD]
[TD]25
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]3/1/18
[/TD]
[TD]3
[/TD]
[TD]35
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]4/1/18
[/TD]
[TD]23
[/TD]
[TD]32
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]4/1/18
[/TD]
[TD]12
[/TD]
[TD]32
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]5/1/18
[/TD]
[TD]3
[/TD]
[TD]80
[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]5/1/18
[/TD]
[TD]4
[/TD]
[TD]80
[/TD]
[/TR]
</tbody>[/TABLE]

So I'm basically trying to create the column with the red text. Matching column B data next to the column D data but just putting a re-occurring value in for the corresponding data from the same date.

Any thoughts?

 

[Tetra201]

Try

=VLOOKUP($C1,$A$1:$B$5,2,0)