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.

[TABLE="width: 592"]
<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>[TR]
[TD="width: 72, bgcolor: transparent"]Coords1[/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[TD="width: 33, bgcolor: transparent"][/TD]
[TD="width: 72, bgcolor: transparent"]Coords2[/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[TD="width: 36, bgcolor: transparent"][/TD]
[TD="width: 72, bgcolor: transparent"]New List[/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[TD="width: 72, bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]X[/TD]
[TD="bgcolor: transparent"]Y[/TD]
[TD="bgcolor: transparent"]Z[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]X[/TD]
[TD="bgcolor: transparent"]Y[/TD]
[TD="bgcolor: transparent"]Z[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"]X[/TD]
[TD="bgcolor: transparent"]Y[/TD]
[TD="bgcolor: transparent"]Z1[/TD]
[TD="bgcolor: transparent"]Z2[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]-0.875[/TD]
[TD="bgcolor: transparent, align: right"]0.25[/TD]
[TD="bgcolor: transparent, align: right"]0.0092[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-0.875[/TD]
[TD="bgcolor: transparent, align: right"]0.25[/TD]
[TD="bgcolor: transparent, align: right"]0.0127[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-0.875[/TD]
[TD="bgcolor: transparent, align: right"]0.25[/TD]
[TD="bgcolor: transparent, align: right"]0.0092[/TD]
[TD="bgcolor: transparent, align: right"]0.0127[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]-0.875[/TD]
[TD="bgcolor: transparent, align: right"]0.375[/TD]
[TD="bgcolor: transparent, align: right"]0.0076[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]500[/TD]
[TD="bgcolor: transparent, align: right"]200[/TD]
[TD="bgcolor: transparent, align: right"]0.002[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-0.875[/TD]
[TD="bgcolor: transparent, align: right"]0.375[/TD]
[TD="bgcolor: transparent, align: right"]0.0076[/TD]
[TD="bgcolor: transparent, align: right"]0.0191[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent, align: right"]-0.875[/TD]
[TD="bgcolor: transparent, align: right"]0.5[/TD]
[TD="bgcolor: transparent, align: right"]0.0165[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]300[/TD]
[TD="bgcolor: transparent, align: right"]100[/TD]
[TD="bgcolor: transparent, align: right"]0.05[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-0.875[/TD]
[TD="bgcolor: transparent, align: right"]0.5[/TD]
[TD="bgcolor: transparent, align: right"]0.0165[/TD]
[TD="bgcolor: transparent, align: right"]0.0172[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-0.875[/TD]
[TD="bgcolor: transparent, align: right"]0.375[/TD]
[TD="bgcolor: transparent, align: right"]0.0191[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent, align: right"]-0.875[/TD]
[TD="bgcolor: transparent, align: right"]0.5[/TD]
[TD="bgcolor: transparent, align: right"]0.0172[/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[TD="bgcolor: transparent"][/TD]
[/TR]
</tbody>[/TABLE]

 

[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.