Can an IF/CONTAIN formula look to another cell to return a value?

Justin Mauzy

Is there a way for the true portion of of the formula return a value_if_true from another cell. If Column 1 contains a specific text string, it would return the value of Column 2?

=IF(CONTAINS("Specific Text", [Column1]:[Column1]), [Column2]))

So for example, the formula would be in Column 3 :

Column 1 @row has HOUSTON

Column 2 @row has Bob Johnson

Column 3 @row would be Bob Johnson

Thank you.

Paul Newcome

Yes. You would use a cell reference.

=F([Column1]@row = "HOUSTON", [Column2]@row)

Paul Newcome

Yes. You would use a cell reference.

=F([Column1]@row = "HOUSTON", [Column2]@row)

Justin Mauzy

Perfect. That worked. Thank you.

Paul Newcome

Happy to help. 👍️

Jared F

I am trying the same thing, look for value in Category (the value is Travel from a drop down list) and if so then return a date in Completion Date. Here is the formula:

=IF(Category@row = "TRAVEL", [Estimated Completion Date]@row)

I get Invalid Column Value error, what am I doing wrong?

Andrée Starå

Hi @Jared F

I hope you're well and safe!

Ensure that the Estimated Completion Date column is a Date Column.

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!