Search Multiple Columns all at once to Find, Locate and return Matching Data Details (Power Query)?

JJL4677 

Thanks, with sample file it's more clear. You may simply add one more column to Names table, entire script is

let
  Source = Excel.CurrentWorkbook(){[Name="Names"]}[Content],
  #"Add Default Email" = Table.AddColumn(
    Source,
      "Default Email",
      each
        try List.Intersect(
              {
                {[Email_1],[Email_2],[Email_3]},
                DefaultEmail[Default Email]
              }
            ){0}
        otherwise null
    )
in
    #"Add Default Email"