Originally Posted by Ron Rosenfeld[_2_]

On Wed, 27 Mar 2013 21:51:13 +0000, laurawolfgang wrote:


Hi all,

I am trying to write an IF statement that returns all non-blank cells
one column over, and if blank, returns the previous non-blank cell in
that column. For example:

A B
1 Apple
2 Orange
3 Strawberry
4
5
6 Grapefruit
7 Banana
8
9 Blueberry

I would like column C to return the following:

C
Apple
Orange
Strawberry
Strawberry
Strawberry
Grapefruit
Banana
Banana
Blueberry

Any thoughts?

Thanks in advance!

C1: =LOOKUP(2,1/(LEN($B$1:B1)0),$B$1:B1)

Fill down as far as required.