I am new to Excel and am assisting someone in doing this task.

User either enter a value or choose it from a drop-down list (Site 1 Name).
With this value, access another
Excel spread sheet to find this value then populate the previous Excel
spreadsheet with
values from the various columns.

For example, user will select HDO094, on the destination spreadsheet. The
marcro will go to the
source spreadsheet locate HDO094 then update the destination spreadsheet with
the Latitude and
Antenna Height information.

Example of the source spreadsheet (second).

Site 1 Site 1 Site1
Name Latitude Antenna Height
HDO094 18.38.57.20:N 42

I appreciate any help with this.