Find value corresponding to 2 values

[deligtvoet]

Goodmorning everyone,

I have an excel file with GPS-coördinates given, existing of 2 values. I want to find the point closest to the 2 given values (in example file collumn F). Is there any way to find the closest point to these 2 values (G&H)and give the corresponding depth (C)?
Problem is the not just the closest value to 1 value (Easting or Northing) is sufficiënt, because they may be 100 meters away from the actual point.

In the best possible way, I would like to find the, say 5, closest points to the given point. So I could get an average value.

Anyone with advise of help please?

Excel-file downloadable from:
http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls

Thanks in advance!
Kind regards

 

[paulotuatail]

Goodmorning everyone,



I have an excel file with GPS-coördinates given, existing of 2 values. I want to find the point closest to the 2 given values (in example file collumn F). Is there any way to find the closest point to these 2 values (G&H)and give the corresponding depth (C)?

Problem is the not just the closest value to 1 value (Easting or Northing) is sufficiënt, because they may be 100 meters away from the actual point.



In the best possible way, I would like to find the, say 5, closest pointsto the given point. So I could get an average value.



Anyone with advise of help please?



Excel-file downloadable from:

http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls



Thanks in advance!

Kind regards

 

[paulotuatail]

Goodmorning everyone,



I have an excel file with GPS-coördinates given, existing of 2 values. I want to find the point closest to the 2 given values (in example file collumn F). Is there any way to find the closest point to these 2 values (G&H)and give the corresponding depth (C)?

Problem is the not just the closest value to 1 value (Easting or Northing) is sufficiënt, because they may be 100 meters away from the actual point.



In the best possible way, I would like to find the, say 5, closest pointsto the given point. So I could get an average value.



Anyone with advise of help please?



Excel-file downloadable from:

http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls



Thanks in advance!

Kind regards

There are difrent ways of giving grid references can you give us the values?

 

[Niels Ligtvoet]

There are difrent ways of giving grid references can you give us the values?

The values are all in the public dropbox link. Collumn A and B are the Easting and Northing Coördinates, while the depth is in C. These are the recorded points, this however is way too much data. I just need the points given in collumn F (name), with their coördinates in G and H. If possible, more values, to get an average depth.

Thanks for the quick respons
Kind regards,
Niels

 

[clist-1]

Goodmorning everyone,



I have an excel file with GPS-coördinates given, existing of 2 values. I want to find the point closest to the 2 given values (in example file collumn F). Is there any way to find the closest point to these 2 values (G&H)and give the corresponding depth (C)?

Problem is the not just the closest value to 1 value (Easting or Northing) is sufficiënt, because they may be 100 meters away from the actual point.



In the best possible way, I would like to find the, say 5, closest pointsto the given point. So I could get an average value.



Anyone with advise of help please?



Excel-file downloadable from:

http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls



Thanks in advance!

Kind regards

I didn't look at your spreadsheet, but if you want to find the closest point to another point you would have to calculate the distances from all otherpoints to that point and then select the smallest distance. This is easily done in Excel.

 

[Niels Ligtvoet]

Thanks, this returns good data!
I calculated the distance between the points (in km), now I've found the 10smallest values, underneath the data (starting from D8957), but now I needto find the corresponding depth. I inserted the depth in between all the collumns. I used =VLOOKUP(D8957;D$2:E$8956;2) to find the corresponding depth, but it returns #N/A...
Any suggestions?
The file is in:
http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls

 

[Niels Ligtvoet]

Goodmorning everyone,



I have an excel file with GPS-coördinates given, existing of 2 values. I want to find the point closest to the 2 given values (in example file collumn F). Is there any way to find the closest point to these 2 values (G&H)and give the corresponding depth (C)?

Problem is the not just the closest value to 1 value (Easting or Northing) is sufficiënt, because they may be 100 meters away from the actual point.



In the best possible way, I would like to find the, say 5, closest pointsto the given point. So I could get an average value.



Anyone with advise of help please?



Excel-file downloadable from:

http://www.dropbox.com/s/2rjdsyu71xivd1m/forum.xls



Thanks in advance!

Kind regards

I've found the error, the data was unsorted.
Thanks for the early respons all!