If formula Across two Columns

[Masond3]

Hi Team 

Hope all is well .

I am after some assistance regarding an if formula which needs to be applied across two column to produce an output in a  new column

Column	Value Name
Category	Ceased
Category	Current
Category	No Match
Helper	[Match]
Helper	[No Match]

Expected Outcome 

If Helper = No Match & Category = Ceased then "0017h00000Vsa7JAAR"

If Helper = No Match & Category = No Match  then "001j000000hbmn3AAA"

If Helper = No Match & Category = Current  then "Investigate"

If Helper = Match & Category = Current  then "Proceed"

I started with a very basic formula but its returning zero results

Formula ;

If [Helper] = "[No Match]" && "[Category]" ="Ceased" then "0017h00000Vsa7JAAR"
Else " " Endif

Regards
Masond3

[pedrodrfaria · Accepted solution]

Hi @Masond3 

I attached below a WF that shows you how you can accomplish this. I created some rows for educational purpose.

Pedro.

[Masond3]

Thank you Pedro, Thats every useful indeed.