Help with excel formula

[Caze982]

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

 

[KRice]

What version of Excel are you using? Here is an approach that should work with any version, but if you have Excel 365, there are better ways:

Book1
	A	B	C
1		MA-nr	Navn
2	107	107	James
3	135	135	Martin
4	135	2358
5	135	2358
6	138	138	John
7	138	150
8	138	149
9	148	148	Paul
Sheet1

Cell Formulas
Range	Formula
A2:A9	A2	=IF(C2<>"",B2,INDEX(B$2:B2,AGGREGATE(14,6,ROW(C$2:C2)/(C$2:C2<>""),1)-ROW(C$2)+1))

...and another idea:

Book1
	A	B	C
1		MA-nr	Navn
2	107	107	James
3	135	135	Martin
4	135	2358
5	135	2358
6	138	138	John
7	138	150
8	138	149
9	148	148	Paul
Sheet1 (2)

Cell Formulas
Range	Formula
A2:A9	A2	=IF(C2<>"",B2,A1)

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Excel formula problem
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.