Comare to column other than key column

[Deepali_Phal]

In the below condition, I want Virtual Queue[Facility] to be compared to Facility[Facility] instead of Facility[_ComputedKey]

[Steve]

help.appsheet.com

SELECT()

Gather column values from row in table or slice

[Deepali_Phal · Accepted solution]

Thanks Steve!

This is the code I used:
IN
([Facility],
SELECT(Facility[Facility],
AND(
([Spots Available] > 0), IN([Facility], Virtual Queue[Facility]))
))