Multiple Criteria in SELECT statement

[adityo_reksopra]

I want to make select stament that filter based on criteria 3 colums :

The Case :

Asset Table:

• Plant Description
• Plant
• Location Description
• New Location Description 

Plant Vs Location Table:

• Location Description (key)

I want to make LoV in valid if in new Location Description that refer to Plant Vs Location and filtered only shown that doesnt equal to in this row 'location description' in Asset Table :

Example :

Asset Table:

• Plant Description
• Plant
• Location Description = a
• New Location Description = Lov : b, c (ref to Plant Vs Location Table in location description column)

Asset Table:

• Plant Description
• Plant
• Location Description = b
• New Location Description = Lov : a, c (ref to Plant Vs Location Table in location description column)

Maybe the formula something like this

Asset Table

SELECT(Plant Vs Location[Location Description], AND([_THISROW].[Plant Description] = [Plant Description]), NOT(IN([Location Description))

how to do that

[Joseph_Seddik · Accepted solution]

Plant Vs Location[Location Description] - LIST([Location Description])

List Subtraction | AppSheet Help Center 

[adityo_reksopra]

@Joseph_Seddik Thank you PERFECT!