HELP!!! - Return the Ancestor Containing a Specific Character

Bill Rigney

Hello,

Level 1

Level 2

Level 3 * The Cell Contents I Need

Level 4

Level 5

Level 6

I'm in a cell in the same row as Level 6 (for example); and I know that a row in the ancestors contains a "*"; how can I retrieve the value contained in the the row that contains the "*"?

Thanks in advance.

Bill Rigney

One last note:

The row with the ancestor containing the "*" could be at any level within the hierarchy.

Bassam Khalil

Hi @Bill Rigney 

Hope you are fine, Please add a copy of your sheet or a screenshot (after removing or replacing any sensitive information). This will make it easier for me to provide the appropriate answer to your question.

Bill Rigney

Hello Bassam,

Here's an example:

Thanks in advance,

Bill