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


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.

Best Answer