mapping 2 tables with 2 fields

hi,@jppuam

    After my research, you can do these as below:

Assume that we have to table like these:

table 1:

table2;

Step1:

use LOOKUPVALUE() function  to search match value

Look Column 2 = LOOKUPVALUE(Table1[Column1],Table1[Column1],Table2[Column2])

Look Column 3 = LOOKUPVALUE(Table1[Column1],Table1[Column1],Table2[Column3])

Step2:

Use this formula to create a table for this match values

Table = DISTINCT(UNION(FILTER(VALUES(Table2[Look Column 2]),Table2[Look Column 2]<>BLANK()),FILTER(VALUES(Table2[Look Column 3]),Table2[Look Column 3]<>BLANK())))

Result:

If not your case, 

please share some data sample and expected output. You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin