| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two linked dropdown list
Hi, i have two dropdown list in A1 and B1.
A B john b32 mary b66 jim b55 cris b88 i need to link somehow this two dropdown list, so when i select in A1 mary, in b1 to appear b32. Or when i select in B1 b88, in A1 to appear cris. but i need both to be dropdown list. Can this be done? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two linked dropdown list
Not easy but it is possible by exploiting the technique described here. It
allows you to have text appear in a cell based on a formula that is in a different cell via the camera tool. http://spreadsheetpage.com/index.php...e_camera_tool/ -- HTH... Jim Thomlinson "puiuluipui" wrote: Hi, i have two dropdown list in A1 and B1. A B john b32 mary b66 jim b55 cris b88 i need to link somehow this two dropdown list, so when i select in A1 mary, in b1 to appear b32. Or when i select in B1 b88, in A1 to appear cris. but i need both to be dropdown list. Can this be done? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| dropdown list determined by another dropdown list | Excel Discussion (Misc queries) | |||
| How do I set up a form with a dropdown linked to another sheet? | Setting up and Configuration of Excel | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| result of selecting from the dropdown list should be a dropdown list | Excel Worksheet Functions | |||
| Change sheet name on linked cell by dropdown box | Excel Worksheet Functions | |||
Linear Mode
