If BLANK input data from cell Above

[Ravey]

Hello,

I'm trying to create a formula where {IF has content stay the same, IF is Blank then add content of cell above}.

Here's what I'm trying to do:
In Cell D2 I want to write a formula that will READ Cell A2 and Copy it if it has content. The same formula is used in D3 which will read A3 and if there is TEXT then copy it, if there is not TEXT then use the TEXT from above cell D2.

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D (I want this in Column D)[/TD]
[TD]E[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Channel[/TD]
[TD]Sessions[/TD]
[TD]
[/TD]
[TD]Channel[/TD]
[TD]Sessions[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]Affiliates[/TD]
[TD]7[/TD]
[TD][/TD]
[TD]Affiliates[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]Affiliates[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]Paid[/TD]
[TD]8[/TD]
[TD][/TD]
[TD]Paid[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD][/TD]
[TD]9[/TD]
[TD][/TD]
[TD]Paid[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]Organic[/TD]
[TD]10[/TD]
[TD][/TD]
[TD]Organic[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]Organic[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[TD]5[/TD]
[TD][/TD]
[TD]Organic[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]

 

[Scott Huish]

In D2:

=IF(A2="",D1,A2)

Copy down.

 

[Steve_R]

Assumes A2 always has a value.

Excel 2010

	A	B	C	D
Channel	Sessions	Channel
Affiliates	Affiliates
Affiliates
Paid	Paid
Paid
Organic	Organic
Organic
Organic

<tbody>
[TD="align: center"]1[/TD]

[TD="align: right"][/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]7[/TD]
[TD="align: right"][/TD]

[TD="align: center"]3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"][/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]8[/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]
[TD="align: right"][/TD]
[TD="align: right"]9[/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]10[/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]
[TD="align: right"][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]
[TD="align: right"][/TD]
[TD="align: right"]5[/TD]
[TD="align: right"][/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: #DAE7F5"]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: #DAE7F5"]D2[/TH]
[TD="align: left"]=IF(ISBLANK(A2),D1,A2)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[Ravey]

That worked thank you!

In D2:

=IF(A2="",D1,A2)

Copy down.