Return last populated cell from column to the left until next populated cell occurs

I hope that title makes sense! Even reading it back it sounds a bit overly cryptic.

I have a column (K) with numbers in there every now and again and I would like column L to populate with the value that most recently occurred.

An example will hopefully explain much better :

This is what I have:
before.jpg

This is what I'd like:
after.jpg

Just in case it makes a difference the value in column K is the result of an IF formula to return non blanks from another column.

Thanks in advance for your help

Many members are unable to see images in the *.png format due to forum compatibility issues with some browsers.

If you need to post an image post it in the *.jpg format.

Even better than posting images... post a SMALL sample file. That way we can test solutions directly in the file with the relevant data.

Maybe like this?

=IF(K1=0,OFFSET(L1,-1,0),K1)

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

Try this...

Data Range

	K	L
1
2	47455	47455
3		47455
4		47455
5		47455
6		47455
7	47466	47466
8		47466
9	47468	47468
10	47471	47471

This formula entered in L2 and copied down:

=LOOKUP(1E100,K$1:K2)

You can also do this
Enter in L2 and copy down

Formula:

Please Login or Register  to view this content.

v	K	L
1
2	65423	65423
3		65423
4		65423
5	987654	987654
6	12321	12321
7		12321
8		12321
9	123231	123231

You're welcome. Thanks for the feedback!

Just for completeness' sake, I opted for the OFFSET version because you can start it in row 1.