Vlookup and joining the sheets

[SahilArora3139]

I have a workflow based on sheet 1 .i have also added one more name for alternative name lookup “Bryne s.”

and i have created the similar workflow for sheet 2 as well.

 I am confused to build a logic after this.

In sheet 2 , i want to delimit the column M . And want to join both the sheets and vlookup the application id with name available to be in affected app. Column. 

can someone help me to build the logic for this.

for reference you can add input data yourself for ref. Otherwise it will work.

i tried text to columns also. But after that unable to join the both workflow and do the vlookup.

any other logic that can be done is most welcome.

thank you in advance