A simple List.Contains an Mcode that can help you save enough time.Learn how to Lookup data in Powerquery