If value exists in one or multiple columns Then...

[raymond]

Dear Community,

a rather simple issue that I fail to solve. 

Initial Situation:

Two or more columns with URLs or a random Text as values.

Sought Output as a new column:

If either one of the columns URL oder Text contain the word "google" then insert "Google" in the Output Column.

The same applies to the other ones >>

- URL oder Text contain the word "xing" then insert "Xing" in the Output Column

- URL oder Text contain the word "facebook" then insert "Facebook" in the Output Column

[Zubair_Muhammad · Accepted solution]

Hi @raymond

Try this Calculated Column. I think Power Query provides an easier way

Output =
IF (
    OR (
        SEARCH ( "Google", TableName[URL],, 0 ) > 0,
        SEARCH ( "Google", TableName[Text],, 0 ) > 0
    ),
    "Google",
    IF (
        OR (
            SEARCH ( "Xing", TableName[URL],, 0 ) > 0,
            SEARCH ( "Xing", TableName[Text],, 0 ) > 0
        ),
        "Xing",
        IF (
            OR (
                SEARCH ( "FaceBook", TableName[URL],, 0 ) > 0,
                SEARCH ( "FaceBook", TableName[Text],, 0 ) > 0
            ),
            "FaceBook"
        )
    )
)