| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IF function with link to different lists
Dear All,
Please help me with the following. Sample: Cell A1 consists of list ("Gold", "Standard"). If I choose "Gold", then B1 must open to the lists of options indicated in cells D1:D10. If I choose "Standard", then B1 must open the list of options indicated in cells E1:E10. I guess I should use VBA. Thank you in advance. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF function with link to different lists
Create a validation list in B1 with the following formula in the Source field:
=IF(A1="Gold",D1:D10,E1:E10) Regards, Stefi €˛Ruslan€¯ ezt Ć*rta: Dear All, Please help me with the following. Sample: Cell A1 consists of list ("Gold", "Standard"). If I choose "Gold", then B1 must open to the lists of options indicated in cells D1:D10. If I choose "Standard", then B1 must open the list of options indicated in cells E1:E10. I guess I should use VBA. Thank you in advance. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
IF function with link to different lists
Visit Debra Dalgleish's site:
http://contextures.com/xlDataVal02.html Ruslan wrote: Dear All, Please help me with the following. Sample: Cell A1 consists of list ("Gold", "Standard"). If I choose "Gold", then B1 must open to the lists of options indicated in cells D1:D10. If I choose "Standard", then B1 must open the list of options indicated in cells E1:E10. I guess I should use VBA. Thank you in advance. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| to link information between two lists | Excel Worksheet Functions | |||
| IF Function with the link to different lists | Excel Discussion (Misc queries) | |||
| link cells in named lists | Excel Discussion (Misc queries) | |||
| For accounting, How to link two lists each in different drop down | Excel Discussion (Misc queries) | |||
| How do you link drop down lists in excel? | Excel Discussion (Misc queries) | |||
Linear Mode
