Select cells if adjacent cell meets condition

Hi All,

What I want to do is very simple, yet I don't have a clue over it. I've a table like,

Select	Task1	Select
Not	Task2	Task1
Select	Task3	Task3

The first 2 columns will be populated from somewhere. And when I enter the value "Select" on the 1st row of 3rd column, I want the remaining rows in 3rd column to be populated based on the value entered ("Select" in this occasion)

I searched a lot and can find only formulas to sum the values. I want to list the values and not sum.

Thanks in advance,
Nivi

what would you expect to see if A2 was "select" as well, or would this not happen?

see if this helps:

EDIT: earlier version of the file (01) had an error, which has now been fixed in the new version (02). i have removed the earlier version.