Search a cell reference and return another cell reference

I am working on a spreadsheet which displays predicated and dependent actions.

For example:
TASK PREDICATED BY DEPENDENTS
A1 TASK 1 NONE TASK 1 (A1)
A2 TASK 2 TASK 1 (A1) TASK 2 (A2)
A3 TASK 3 TASK 2 (A2)

I want to create a formula to search column C for references to the current row and return the text from column A in that row if it is true.
Something like: =IF(search("a",c?),"aROW", "none"
where "c?" would search all of column c and "aROW" would return the value from column a of the searched row for every positive result.
Not sure if this is even possible. Thanks for the help.

Chris

Thanks for the quick reply! Hope this helps. Just a really rough example of what I am doing. That actual connection tree is far more complicated.

Chris

Try this approach

Select D2:Z2 and paste the following array formula (CSE --> CTRL+SHIFT+ENTER)

Formula:

Please Login or Register  to view this content.

and copy select cells (D2:Z2) down

Note: You can extend the number of columns to the maximum number of dependents COLUMN(A$1:Z$1)

See the file flow chart spread sheet sample.xlsx

I'm basically trying to fill column B with the relevant data from column C.

Hi

See the file flow chart spread sheet sample(1).xlsx

Thanks Jose! It took some tweeking but I got it to work in my other spread sheet. Brilliant!