| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create multi choice selec drop down list in Excel please | Excel Discussion (Misc queries) | |||
| How do I create multi choice selec drop down list in Excel please | Excel Worksheet Functions | |||
| Multi-select from drop down list in Excel 97 | Excel Discussion (Misc queries) | |||
| Multi-Column Drop-down list ? | Excel Discussion (Misc queries) | |||
| Drop down list changes, worksheets and multi-user | New Users to Excel | |||
Linear Mode
