Extracting text from a column and comparing on that column

 SortByColumns(Filter(coll_Area,   Result in Filter(AddColumns('Maintenance Notification',"AreaName",Trim(

     Last(FirstN(Split('Functional Location', "-"),4)).Value))

,("LUX-"&cmb_filerFuncLocation.Selected.Value) in 'Functional Location' ).AreaName || Result in Filter('Maintenance Notification',("LUX-"&cmb_filerFuncLocation.Selected.Value) in 'Functional Location' ).Area),"Result",SortOrder.Ascending)