Lookup with an if condition

[PaulaL]

Hi, I am having issues with incorporating an If statement into my LOOKUPVALUE formula (if this is even the correct way to approach it)

I am using theInstalledSoftware table as my Main table where I would like to display the information... I need to lookup the information from the Merge1 table and but I only need to copy the information into InstalledSoftware if the ProductName column has the word %project% in it (I need project to be inside a wildcard or similar to a like function as there are mutliple different versions)

Table Names: Merge1 & InstalledSoftware 

LOOKUPVALUE COLUMN

Column = LOOKUPVALUE(Merge1[XLS_Project Online.Licence],Merge1[Netbios_Name0],InstalledSoftware[vSMS_R_System_NetBIOS])

Any help would be greatly appreciated

[ChrisMendoza · Accepted solution]

@PaulaL -

If you have a relationship between the tables, this works in my small sample:

Column =
IF (
    SEARCH (
        "product",
        RELATED ( Merge1[productName] ),
        1,
        0
    ),
    RELATED ( Merge1[productName] )
)