If it finds certain text, type

[therealaccountant]

Hi everyone. I have two columns that I need formulas on. Columns D and E.
If it finds "Yes" in column B, to show up on column D. If its blank to show up on column E.

See the attached. Column D and E has what I need those cells to be.

Thank you!!!

[sgstevenlow]

try
D1
=IF(B1="Yes",A1,"")

E1
=IF(B1="",A1,"")