Hi everyone. I have tried to illustrate my problem below with the arrows.

I cell A5 i need a formula that looks i cell C5 and if it is empty then goes up and finds the next cell that is not empty in column C. Then goes one cell left ( in this case cell B3) and then pastes that value in cell
A5. In this case the value in cell A5 would then be 135. Does anyone know how to create a formula like that?

Sincerely
Christian

Udklip.JPG