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
Hey @tiverson how does this look? Seems to work for your example! Any issues let me know. Workbook attached.