Potential If Statement

[Anonymous]

Hello, 

I am Looking for a way to do the following

The results are highlighted in Yellow.

The Lookup Array would be the Well Name

Find a Match in the Origin Column and Destination Column

Pull the Last 2 Characters from the Matching Name

[ChrisMendoza · Accepted solution]

@Anonymous -

This could do the trick as a column:

Column = 
VAR searchOne =
    SEARCH ( TableName[Well], TableName[Origin], 1, FALSE () )
VAR searchTwo =
    SEARCH ( TableName[Well], TableName[Dest], 1, FALSE () )
VAR Result =
    IF (
        searchOne,
        RIGHT (
            TableName[Origin],
            ( LEN ( TableName[Origin] ) - FIND ( ",", TableName[Origin], 1 ) - 1  )
        ),
        IF (
            searchTwo,
            RIGHT (
                TableName[Dest],
                ( LEN ( TableName[Dest] ) - FIND ( ",", TableName[Dest], 1 ) - 1 )
            ),
            BLANK ()
        )
    )
RETURN
    Result