Drop down list for multi cells
 

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

Drop down list for multi cells
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"jsw" wrote:

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

Drop down list for multi cells
 

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" wrote:

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

Luke M
*Remember to click "yes" if this post helped you!*


"jsw" wrote:

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

Drop down list for multi cells
 

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

=VLOOKUP(A5,A1:B3,2,FALSE)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jsw" wrote:

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" wrote:

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

Luke M
*Remember to click "yes" if this post helped you!*


"jsw" wrote:

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