Fill down with conditions

[tiverson]

I am trying to fill down a account mapping table

I want to create a "Title" column that will list the applicable description form the level.

For the title, I want to use the Level that has text, unless all of them are blank, then I want to use the value above it.

Would I use a nested "IF" statement with the multi row formula?  Or is there another solution?

I am struggling with nested, conditional "IF" statements

Desired output

[DataNath]

Hey @tiverson how does this look? Seems to work for your example! Any issues let me know. Workbook attached.

[AngelosPachis]

Hi @tiverson ,

To supplement @DataNath provided solution, here's another take that's slightly more dynamic in case more levels crop up in the future

Cheers,

Angelos

[binuacs]

@tiverson Another way of doing this