Match X,Y point in list 1 to nearest X,Y point in list 2

Hi,

I have a long list of X,Y,Z map points and another, much shorter list, of X,Y target points. The target points will not exactly coincide with the map points. I want to take each target point and then match it to the nearest X,Y map point and return the Z value.

The attached Excel sheet should make this clear.

I thought this would be easy but have had problems, so would appreciate if anyone can provide some pointers!

Thanks,

Hamang