Fill in missing date with 2 conditions by copy paste

[jca0078]

Hi there,

I'm trying to fill in missing dates on my "B" Column by searching empty cells within the column and comparing those empty cells with their parallel "C" Column cells for data. Upon meeting the 2 conditions, the formula would copy the date immediately above the empty "B" cell and paste to the empty "B" cell that has data to its right side on the "C" column. I have hundreds of these empty cells for which I need to replicate the date and thought a formula would help but have no idea how to write it.

Here's a basic concept of what my more complex worksheet looks like:

[TABLE="width: 450"]
<tbody>[TR]
[TD="width: 65"]A[/TD]
[TD="width: 65"]B[/TD]
[TD="width: 65"]C[/TD]
[TD="width: 65"]D[/TD]
[TD="width: 65"]E[/TD]
[TD="width: 65"]F[/TD]
[/TR]
[TR]
[TD="width: 65"][/TD]
[TD="width: 65"]Dates[/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[TD="width: 65"][/TD]
[/TR]
[TR]
[TD]Nathan[/TD]
[TD="align: right"]01-01-15[/TD]
[TD] apples[/TD]
[TD="align: right"]$15[/TD]
[TD]Nuts[/TD]
[TD="align: right"]$10[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD="align: right"]01-01-15[/TD]
[TD] apples[/TD]
[TD="align: right"]$11[/TD]
[TD]sweets[/TD]
[TD="align: right"]$5[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Nuts[/TD]
[TD="align: right"]$9[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mary[/TD]
[TD="align: right"]01-02-24[/TD]
[TD]Bananas[/TD]
[TD="align: right"]$5[/TD]
[TD]Tomatoes[/TD]
[TD="align: right"]$8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Greens[/TD]
[TD="align: right"]$12[/TD]
[TD]Nuts[/TD]
[TD="align: right"]$6[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Tom[/TD]
[TD="align: right"]01-02-27[/TD]
[TD]Bananas[/TD]
[TD="align: right"]$7[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]