Help with formula to find matching coordinate values, make new list

[Slewis]

I have two lists of coordinates, X,Y,Z. One list is significantly longer than the other as has additional non matching X,Y values. The Z values are purposely different. At the end of the day I want to compare the different Z values between matching X,Y coordinates

What I want to do is find the matching coordinates X,Y and create a new list of only the matching X,Y, values but keeping the different Z values.

Coords1				Coords2				New List
X	Y	Z		X	Y	Z		X	Y	Z1	Z2
-0.875	0.25	0.0092		-0.875	0.25	0.0127		-0.875	0.25	0.0092	0.0127
-0.875	0.375	0.0076		500	200	0.002		-0.875	0.375	0.0076	0.0191
-0.875	0.5	0.0165		300	100	0.05		-0.875	0.5	0.0165	0.0172
				-0.875	0.375	0.0191
				-0.875	0.5	0.0172

<colgroup><col width="72" style="width: 54pt;" span="3"> <col width="33" style="width: 25pt; mso-width-source: userset; mso-width-alt: 1056;"> <col width="72" style="width: 54pt;" span="3"> <col width="36" style="width: 27pt; mso-width-source: userset; mso-width-alt: 1152;"> <col width="72" style="width: 54pt;" span="4"> <tbody> </tbody>

 

[stunnrock]

Are there always only going to be two values for Z, one from Coords1 and one from Coords2?

 

[stunnrock]

If that is the case, you only need to repeat Coords1 in columns I:K and add this in column L:

=IFERROR(INDEX($G$3:$G$10,MATCH($I3&"¬"&$J3,INDEX($E$3:$E$10&"¬"&$F$3:$F$10,),0)),"-")

If not, it may be worth providing some further explanation of the content of your lists.