Home |
Search |
Today's Posts |
#1
|
|||
|
|||
drop down box
I got 2 sheet the first has got 3 cell on it, this is the one that I want to
make the drop down box lookup, the layout is "Post_Code", "Town", "Description", the postcode cell is one referance, while the town may have muiltable referance, as the same with the description, ex postcode town description 2166 Maffra Nsw Zone1 3860 Maffra Victoria Zone 3 3850 Sale Victoria Zone 3 I need it to lookup on the town and refrance on the description, but when there is muiltable refrance it take the first only, the drop downn needs to be the town, any idea. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can you make a drop down list in a drop down list? | Excel Discussion (Misc queries) | |||
multiple select from the drop down list in excel. list in one sheet and drop down in | Excel Discussion (Misc queries) | |||
advanced: synchronizing data value across two worksheet drop boxes | Excel Worksheet Functions | |||
formulas for drop down menus | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions |