Trying to return clostest point or points with a given cordinates

[barcelonat]

[TABLE="width: 500, align: right"]
<tbody>[TR]
[TD]ID
[/TD]
[TD]X
[/TD]
[TD]Y
[/TD]
[TD]Date
[/TD]
[/TR]
[TR]
[TD]A
[/TD]
[TD]519333
[/TD]
[TD][/TD]
[TD]09/12/2017
[/TD]
[/TR]
[TR]
[TD]B
[/TD]
[TD]52712
[/TD]
[TD][/TD]
[TD]10/06/2018
[/TD]
[/TR]
[TR]
[TD]C
[/TD]
[TD]...
[/TD]
[TD]..
[/TD]
[TD]...
[/TD]
[/TR]
</tbody>[/TABLE]
Hello,

I am tryin to return the ID of the one or multple corridates that are a given disance away from anotehr ID.
There are for columns. The 1stis th a unique ID. The 2nd and 3rd would e th eastign northing, a fve digit number. The 4th the date.

My table is one sheet, the output is on another. The output sheet would have cell where you would input the distance (m) you want to search from a prticular ID that would also be in the dataset. And a cell where where you would wirt teh ID of the point you are cheking from. I would then hopefully get a list of points that are witin the given distance ( so + and - Xm for both the easting and northing), not returning the ID of the point you are using to search from. I would also want to limit results to 1 year previously.

I hae tried doing this with INDEX, MATCH and IF functions but gettingin one hell of a mess.

Thanks for any help.

Dan