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