Error: Powerbi lookupvlaue returns multiple values

How do I solve this problem other than concatenatex the values to be returned? I want each returned value to generate a separate piece of data.  e.g. newcolumn=lookupvlaue(  table2 a  ,  tabl...