Searching a Workbook for Closest X&Y Coordinates

[Impartial Derivative]

I have a workbook that lists x and y coordinates for different particles in each respective frame of an time-lapse image file. I am trying to analyze data for given particles and their nearest neighbor ( closest x and y) out of the data set. I was wondering how or if I can accomplish this in excel to potentially be incorporated in a data analysis macro. I'd really like to set up some kind of formula where Excel reads the frame number of the coordinates I'm looking to find the neighbor of and then searches all of the entries in the spreadsheet corresponding to that same frame number and then displays the coordinates of the nearest particle. I've been playing with the MATCH function but I'm not sure if it can really be used for what I'm trying to do. As always any help or advice would be greatly appreciated.