How to transfer geodata from one table to another by entering only the label name?

Question

Google Sheets

There is a table that contains geographic labels from the map with names (column "Name") and the coordinates of these labels ("Longitude", "Latitude", respectively)
There is a second table that "draws" a line from these labels on the map.
It is necessary that when entering the label name in the second table (NY0001, for example), the coordinates are automatically loaded from the first table. Please tell me a convenient way.

Answer 1

= VLOOKUP(query, range, index, [sorted])