| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
IF Function with the link to different lists
Dear friend. Please help me with the following. I want to create a formula
(perhaps must be realized via VBA) that .. depending on what I choose in A1 cell ("standard" or "gold" options) cell B1 must provide me with the according list of options. For example, If I choose Standard in A1, cell B1 must show me the list indicated in D1:D10 or if I choose Gold in A1, cell B1 must shopw me the list in E1:E10. Thanks you very much in advance. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Function with the link to different lists
Look he
http://www.contextures.com/xlDataVal02.html "Ruslan" wrote: Dear friend. Please help me with the following. I want to create a formula (perhaps must be realized via VBA) that .. depending on what I choose in A1 cell ("standard" or "gold" options) cell B1 must provide me with the according list of options. For example, If I choose Standard in A1, cell B1 must show me the list indicated in D1:D10 or if I choose Gold in A1, cell B1 must shopw me the list in E1:E10. Thanks you very much in advance. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
IF Function with the link to different lists
What you're looking for is "dependant lists".
Check out this web page of Debra Dalgleish on this subject: http://www.contextures.com/xlDataVal02.html -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Ruslan" wrote in message ... Dear friend. Please help me with the following. I want to create a formula (perhaps must be realized via VBA) that .. depending on what I choose in A1 cell ("standard" or "gold" options) cell B1 must provide me with the according list of options. For example, If I choose Standard in A1, cell B1 must show me the list indicated in D1:D10 or if I choose Gold in A1, cell B1 must shopw me the list in E1:E10. Thanks you very much in advance. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using the paste link function in Excel 2003 | Excel Worksheet Functions | |||
| How do you link drop down lists in excel? | Excel Discussion (Misc queries) | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
| carrying a hyper link when using the vlookup function | Excel Worksheet Functions | |||
Linear Mode
