Hi.
I am trying to produce a drop down list for my mileage records.
Basically, I have locations A,B,C,D with their mileage in the next cell ie
10,20,30,40.

On my main sheet I want to be able to select the locations from a drop down
box and excel fill in the location and associated mileage in two cells.

I can easilly use 2 drop down boxes for locations and mileage but this means
I have to remember how far it is to each location.

ANy help on how to do this?

Thnaks