Combining Data out of two sheets

[Nils_Junker]

Hi everybody,

I have to combine two excel sheets.
The first sheet contains the time, tmeperature, longitude and latitude.
The second one has an identifier and also longitude and latitude.

The second sheet got round about 500 dataasets.

Now I have to find the dataaset which is the closest to one from the first sheet.

First sheet

Second sheet

Is there a formula I can use?
Thanks for your support

 

[Skybluekid]

Is the matching criteria on the Long and Lat?