There is something I don't understand. In each of your sets, what is
the meaning of column Ref#? Are these actual data? Because, if they are
just the locations, all you need to do is copy data set 2 next to 1.

If, on the other hand, you do have a column *containing* cell
references and you want to transfer these data to their corresponding
rows next to set 1, you can use the following: Next to Set1 (say in
C2), enter the formula:

=F(ISNA(VLOOKUP(A2,K:L,2,0)),"",VLOOKUP(A2,K:L,2,0 )

Here I assume that dataset2 occupies columns K:L.

Does this help?

Kostis Vezerides