Hi there!

I'm doing an google sheets to-do list, and long story short, I need to be able to extract values from a text field, look them up, and check the contents of their cells. I have one column that tells me if a task is ready to be done or not. This works fine if there's only one task that it's dependent on, and I'm using the formula below:

Please Login or Register  to view this content.
B is the number of the task (I'm using numbers like 2.15, to group tasks together). C is where I list dependencies, and E is where I say whether or not it's complete (YES or blank).

I'm wondering if there's a way to do multiple VLOOKUPS from one block of text. Right now I'm listing multiple dependent tasks as "20.15;20.2;20.25". I know I can split the text into those numbers with SPLIT, but when I enter that in (as below, replacing the IF/VLOOKUP expression within the first formula) it doesn't work as expected, rather it's only dependent on whatever number is first in the text string:

Please Login or Register  to view this content.
Is there a way to get it to check if any of the values that come out of SPLIT have "YES"? If not, is there another way I can list them that would be easier?