Formula to Show Data from Child Row on Parent Row

Andy Lorance

Greetings -

I am looking for a way to show the data from the first child row onto the parent row.

Example:

Parent Row = blank

Child row 1 = blank

Child row 2 = TEXT

Child row 3 = TEXT

The formula on the parent row would yield the text from child row 2

Mark Cronk

Hi @Andy Lorance ,

Try entering this in the parent row. Use the right row # for your sheet:

=IF(NOT(ISBLANK(Child1)), Child1, Child2)

If you need to go down more child rows you can repeat the IF statement until it find a cell that is no blank.

Work?

Mark

Andy Lorance

Hi, Mark - thanks for the reply!

The sheet data is dynamic; the parent rows will move around as a result. I'm hoping to find a solution that I can convert into a column formula.

Thanks!

Andy