Hi gurus!

I have 20 named locations in a coordinates. Every point have x,y.

column a has the location name
column b has the x cooedinate
column c has the y coordinate

Now i have 400 coordinates in 2 columns (column e and f ) and want to
have the name of
the closest location (of the 20 named in column a) in column g.

I have tried with array formulas and Phytagoras - but no succes.

Help needed

Thanks in advance!