Drop down list for multi cells

[jsw]

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

 

[Luke M]

For the mileage cell, take a look at the LOOKUP or VLOOKUP functions.

 

[jsw]

Thnaks.
I have had a look but can't get it to work.

I have locations in A1-A3 and mileage in B1-B3.
In A5 I want to pick the location from a drop down box and it fill in the
location (in A5) and mileage in B5.

 

[Luke M]

You'll still need your drop down box in A5. Formula in B5 should be:

=VLOOKUP(A5,A1:B3,2,FALSE)