Merge two related data sets by common value, Libre

Question

I have two datasets, they are stored separately but they are related, they describe the same phenomenon, from different perspectives, in different ways.

The encoding is not really consequential, here they are rendered as Excel/LibreOffice but I can also get them as CSV.

One "sheet", Sheet I, looks like this:

and Sheet II:

Using the field submission # as the unifier I want to create a single sheet which will associate the related blue fields to the corresponding pink field.

For example, the final result should look like this:

Here is a link to those toy examples.

Answer 1

On sheet1 cell h2 insert:

=VLOOKUP($B2,Sheet2!$A:$F,COLUMN(h2)-6,0)

The $ fixes the data table and the row for the lookup. You can drag the function with the black plus sign which appears when you are pointing the right bottom of the cell.