I am trying to create a formula where if a word is found within a certain column, it writes the text found in another cell. If not, then it does nothing.

I have tried =IF(A1="need to schedule",A2,"") then just drag the formula down to apply it to the whole column. This works okay, however I would preferably like it to create a list instead of writing response in corresponding cells.

Ex: If A1 and C1 contain the text "need to schedule" while B2 is blank and I type the formula into cell E1, I want E1 to say "A2" and E2 to say "C2". Is this even possible? (Sorry for any confusion)