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