Hi Rob,

I believe using VLOOKUP can do what you want.

With the location name in column A and the latitude in column B and the
longitude in column C and the drop down cell is F1...

In G1 =VLOOKUP(F1,A1:C100,2,0) for the Lat
In H1 =VLOOKUP(F1,A1:C100,3,0) for the Long

HTH
Regards,
Howard

"Rob" wrote in message
...
I am trying to create a drop down box that will automatical populate other
boxes.
I have a worksheet with a list of Locations with their latidue and
longitude
coordinates. I am trying to make a drop down box in another worksheet
where
I select the location and then excel automatically fills in the next 2
colums
with the lat/long data. Is there a way I can make this happen?