|
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.
|