Matching Column B with A, and then sorting B with its expanded selection.

I have to sets of data.

The first set is just a bunch of IDs.

The second set is the same set of IDs and other data related to each ID.

But the second set of IDs is not in the same order as the first set.

So how do I get the second set to match up in the same order as the first set and also sort the items related to it?

So, here is an example:
Screen Shot 2017-02-08 at 20.10.47.png

I need to get from that to the follwing:

Screen Shot 2017-02-08 at 20.11.38.png

Anyone know the simplest way to do this, keeping in mind that the 2nd set has to be sorted along with its relations?

JH

Suggest using the VLOOKUP function.

e.g in F2 type

=VLOOKUP(A2,C:D,1,0)

and in G2

=VLOOKUP(A2,C:D,2,0)