Hi
I created 2 dynamic range for your Id in columns A of both sheets.
In result sheet in A2, put this Array formula and copy down.
=IFERROR(IF(ROWS(A1:$A$1)<=SUM(1/COUNTIF(List1;List1));INDEX(List1;MATCH(0;COUNTIF(A1:$A$1;List1);0));INDEX(List2;MATCH(0;COUNTIF(A1:$A$1;List2);0)));"")
In b2 and copy down and across, this regular one.
=IFERROR(IFERROR(INDEX(Master!B$2:B$1000;MATCH(Results!$A2;Master!$A$2:$A$1000;0));INDEX(Update!B$2:B$1000;MATCH(Results!$A2;Update!$A$2:$A$1000;0)));"")
Change ALL semi colons to comma.
Is this works for you?
Bookmarks