Fill data based on cell reference

[premjeet]

Greetings,
I need some help for below problem.

If below entry shows in any cell (data comes from a formula) then only the next NA column cell should have the same data.

260SCX2
130SCX10

I have tried to use following formula but the result coming in continuation manner not for the only the next column cell.
=IF(OR(D7="260SCX2",D7="130SCX10"),D7,"Orignal Result")

If anyone could please help on this. Thanks in advance.

Orignal Post : Auto data fill based on previous cell value reference.

 

[premjeet]

This problem is resolved on other forum.

Auto data fill based on previous cell value reference.

Please check attached sheet is having two tables. First is the value I am getting with my own formula reference second table shows expected result. I am looking for a formula reference. If below entry shows in any cell then only the next cell should have the same data. 260SCX2 130SCX10 112SNX10...

chandoo.org

Thanks.