I have 3 tables in 3 sheets. The email column is where the data is identified. Which means the emails will be unique in the expected results sheet after joining

First Second

Third

CodePudding user response：

There are three formulas in cyan on the tab called MK.Help in this editable copy of your sheet:

This is the one for the second set of names:

=ARRAYFORMULA({Second!A1:E1;ARRAY_CONSTRAIN(IFERROR(VLOOKUP(C2:C,{Second!D:D,Second!A:E},{2,3,4,5,6},0)),COUNTA(C2:C),5);FILTER(Second!A2:E,Second!D2:D<>"",ISNA(MATCH(Second!D2:D,C2:C,0)))})

That do what you're hoping?